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,...
User Profile
Collapse
-
Export table to dbf file and right codepage with DoCmd.TransferText
This is my code:
Code1:
Code:'DoCmd.OpenTable "tblImport" 'DoCmd.TransferDatabase acExport, "dBASE IV", strOutputDir,acTable,"sel_TblImport", strDbfName & ".dbf", False ' DoCmd.Close acTable, "tblImport"
Code2:
Code:DoCmd.TransferText acExportDelim, sImportSpecification, "sel_TblImport",
No activity results to display
Show More
Leave a comment: