Automate exporting an Access table to DB5

[Walloe50]

I have a number of Access tables that are created monthly. These tables are then manually exported to DB5 to be taken in by a SAS program.
Is there a way I can automate exporting these Access tables to the DBF (DB5)?
Thanks

 

[earthandfire]

Try

DoCmd.TransferDatabase acExport, "dBase 5.0", "Drive:Folder\", acTable, "AccessTableName", "DBaseFileName", False

Hope this helps.

 

[Walloe50]

Thanks Earthandfire, but I forgot to mention that VB is a foreign language to me. Would this be the only code I would need to perform this function?

AML

 

[dhulbert]

Goto modules, create a new module and add some code as below to the module

Sub export_tables()

  DoCmd.TransferDatabase acExport, "dBase 5.0", "Drive:Folder\", acTable, "AccessTableName", "DBaseFileName", False
  DoCmd.TransferDatabase acExport, "dBase 5.0", "Drive:Folder\", acTable, "AccessTableName", "DBaseFileName", False
  DoCmd.TransferDatabase acExport, "dBase 5.0", "Drive:Folder\", acTable, "AccessTableName", "DBaseFileName", False
  DoCmd.TransferDatabase acExport, "dBase 5.0", "Drive:Folder\", acTable, "AccessTableName", "DBaseFileName", False

End Sub

repeat the docmd line as many times as required and remember to change the File Path, and table names for each export.

Then all you have to do each month is run the code and the tables will be exported.