Sample code

[malik]

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

 

[Joel]

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.