Export syntax to DBASE

  • Thread starter Thread starter ike
  • Start date Start date
I

ike

Hi all-

Do you know what the syntax code is to automatically
export a SQL table to a DBASE file format? I have to
embed this code behind the scenes so the user does not
have to manually export it. Thanks!

Ike
 
-----Original Message-----
Hi all-

Do you know what the syntax code is to automatically
export a SQL table to a DBASE file format? I have to
embed this code behind the scenes so the user does not
have to manually export it. Thanks!

Ike
.
Click to expand...
Hey Ike

Syntax is as follows:

DoCmd.TransferDatabase acExport, "dBase iv", "c:\Folder\",
acTable, "AccessTableName", "Output.dbf"

Make sure you save the output file name is in DOS 8.3
format.
 
Back
Top