I'm trying to a VBA docmd.TransferText statement (properly formatted) to import and append "csv" data to an existing table, e.g.
.
The VBA code creates a new table with an identical name, while a manual import properly appends the existing table.
Can VBA be used to append an existing table with a TransferText statement?
What am I missing.
PHP:
DoCmd.TransferText acImportDelim, "Import Specification", "tbImportedData", strPathAndFile, vbNo
The VBA code creates a new table with an identical name, while a manual import properly appends the existing table.
Can VBA be used to append an existing table with a TransferText statement?
What am I missing.