TransferDatabase command

[Gez]

Hi,

I want to export a table to a dbf file using VBA in the same way that I can
right click on table and select export and save it as a new dbase 5 file.

The problem I'm having is that the TransferDatabase method is looking for an
exiting database to export to when all I need it to do is to create a new
one. Help!

Cheers,

Geraint

 

[Arvin Meyer]

Access stores this information in an *.inf file in the Office program
folder. Find the line that referes to the database that you are trying to
export, and delete it.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Gez]

Isn't it the case that the transferdatabase command only transfers from one
database to another.

All I want to know how to do is to create a new dbf file on the fly in VBA
so that the transferdatabase command can export to it.

How will deleting the .ini file help?

 

[Van T. Dinh]

Use TransferDatabase Method but read the Access VB Help topic on the
TransferDatabase Method *carefully* as the option values used to export to
dbf format is rather confusing.