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
|