Export syntax to DBASE

[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

 

[Dan]

-----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
.

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.