Exporting table as DBF

Soma_rich

Registered User.
Local time
Today, 15:42
Joined
May 2, 2007
Messages
58
Hi using access 97 how do I programmatically export a table in DBF format? You can do this by right clicking the table and exporting but I can not find the function in VB.
Thanks
 
Got it now!

DoCmd.TransferDatabase acExport, "dBASE IV", "c:\temp", acTable, "Currency", "Currency.DBF"

Thanks
 
ah... dBase. The good old days. :)
 

Users who are viewing this thread

Back
Top Bottom