The following line will take the structure and data in a table called
MyTable and export it to dBase IV format in the directory,
"C:\Project", by creating 3 new files: MyTable.dbf, MyTable.mdx and
MyTable.INF. The mdx file is an index file, and the inf file contains
info that Access can use to link to the data, if you need to:
docmd.TransferDatabase _
acExport,"dBase IV","C:\Projects",acTable,"MyTable","MyTable"
-- Andy
Quote:
>I've looked through the help and can't seem to find how to export to dBaseIV
>(as you can in the File Menu export) I'm having no problem with other
>formats but the dBase doesn't seem to be there. What am I missing?? Please
>provide a few details.
>Thanks in advance.
>Joe
>>Check the help topic for: TransferDatabase Method
>> -- Andy
>>>I'm quite new to VBA, but I can't seem to find how to automatically export
>a
>>>table as a dBase IV format.
>>>What am I missing??
>>>Thanks in advance, have a wonderful Holiday,
>>>Joe
Export Table as dBASE IV