Sample code
I have 31 dbf file which I received daily. I need to extract information from
this file daily i.e day 1 .... day 31 into excel fixed spreadsheet. Information need to extract from this dbf file under the field below Accode Acdesc Type Closebal Tbdate Excel standard format as per below Column A Column B Column C Column D Column E Column F to AI Accode Acdesc Type Closebal Tbdate Day 1 and so on Thank you -- malik@fifi |
Sample code
The best way of getting code when importing data from a database is to use a
learn macro. the code can be modified if necessary later. 1) On worksheet go to Tools - Macro - record New Macro 2) Import data using menu data - import external data - import data. then manually select the data you want to import. You could also do a query. 3) then stop recording. If you need modification then post the record code so changes can be made. "malik" wrote: I have 31 dbf file which I received daily. I need to extract information from this file daily i.e day 1 .... day 31 into excel fixed spreadsheet. Information need to extract from this dbf file under the field below Accode Acdesc Type Closebal Tbdate Excel standard format as per below Column A Column B Column C Column D Column E Column F to AI Accode Acdesc Type Closebal Tbdate Day 1 and so on Thank you -- malik@fifi |
All times are GMT +1. The time now is 09:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com