How do I automatically export a table to a dbiii file from Access.

[Guest]

I currently use the transfer text action in macros to import delimited text
files into an Acces Database. What I am trying to do is setup a macro to
transfer or export the information from those tables into dbIII files. Is
this possible???

 

[Brendan Reynolds]

You can do that using the TransferDatabase action. Here's a link to the
on-line help topic ...

http://msdn.microsoft.com/library/d...c11/html/acactTransferDatabase_HV01122181.asp

 

[Guest]

The TransferDatabase action seems to only allow me to export the table to
another database, not just into a dbIII file. What's I'm looking to do is
just create a .dbf file from the data in a table like you can when you
manually export the table.
here is what my action looks like:

Tranfer Type: Export
Database Type: Dbase III
Database Name: original database.mdb
Object Type: Table
Source: Name of table to export from
Destination: path\name of table.dbf
Structure Only: No