export from ms access

[foker500]

I'm trying to export a table from ms access to a .dbf. I know this is probably really easy but I can't figure it out??? Any direction would be greatly appreciated.

Windows XP
Pythonwin 2.1

[jlm699]

I'm trying to export a table from ms access to a .dbf. I know this is probably really easy but I can't figure it out??? Any direction would be greatly appreciated.

Windows XP
Pythonwin 2.1

What? Is this a python question or are you just in Microsoft Access trying to save a table in a certain format?

[foker500]

What? Is this a python question or are you just in Microsoft Access trying to save a table in a certain format?

I'm trying to import several .csv files to ms access, manipulate the table schema, then export to .dbf. I'm trying to automate this using python and have everything figure out except for the 'export' to .dbf. Sorry, did mean to be so vague.

[jlm699]

I'm trying to import several .csv files to ms access, manipulate the table schema, then export to .dbf. I'm trying to automate this using python and have everything figure out except for the 'export' to .dbf. Sorry, did mean to be so vague.

Can you give a quick snippet of your code where you want to save?

[Cuaracao]

Hi
Try like this:

'DoCmd.OpenTabl e "tblImport"
'DoCmd.Transfer Database acExport, "dBASE IV", strOutputDir,ac Table,"sel_TblI mport", strDbfName & ".dbf", False
'
DoCmd.Close acTable, "tblImport"

=============== =============== =============== ===== ======

Code2:

DoCmd.TransferT ext acExportDelim, sImportSpecific ation, "sel_TblImport" , strOutputDir & strDbfName & ".dbf", , , 65001