Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error 424 for sample code? | Excel Programming | |||
do anybody have a sample code for executing excel macro from vb code?<eom | Excel Programming | |||
Need sample code | Excel Programming | |||
Registration Key Sample Code | Excel Programming | |||
Need Sample VBA Code | Excel Programming |