epicazo
asked on
How to Programatically export comma delimted to CSV
I tried to programatically export to a CSV file, comma delimted, but the following didn't produce the results I expected. The DoCmd I am using below doesn't export as comma delimted.
DoCmd.OutputTo acOutputTable, "tbl Export Current Charges", acFormatCSV, "C:\Siemens\Xport_HistoryD ata\201008 31\ELA\MYT EST_CHARGE S.CSV"
I have about 10 tables that are exported weekly and the varDateFolder changes weekly (It will always be the prior sunday in YYYYMMDD format.
DoCmd.OutputTo acOutputTable, "tbl Export Current Charges", acFormatCSV, "C:\Siemens\Xport_HistoryD ata\"+varD ateFolder+ "\Group1\M Y_CHARGES. CSV"
DoCmd.OutputTo acOutputTable, "tbl Export Current Charges", acFormatCSV, "C:\Siemens\Xport_HistoryD
I have about 10 tables that are exported weekly and the varDateFolder changes weekly (It will always be the prior sunday in YYYYMMDD format.
DoCmd.OutputTo acOutputTable, "tbl Export Current Charges", acFormatCSV, "C:\Siemens\Xport_HistoryD
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Capricorn,
I gave you the points without testing. I am now trying to implement and I get the following error:
The export file does not exist....
DoCmd.TransferText acExportDelim, "Export_CHP_ToRadBillingSF TP", "X_RadBilling", "F:\RadAdvocate\RAD_Billin g_CHPYYYYM MDD.CSV", True
I gave you the points without testing. I am now trying to implement and I get the following error:
The export file does not exist....
DoCmd.TransferText acExportDelim, "Export_CHP_ToRadBillingSF
ASKER
Here is the error....
RUN-TIME ERROR '3625'
"THE TEXT FILE SPECIFICATION 'EXPORT_CHP_TORADBILLINGSF TP' DOES NOT EXIST...."
RUN-TIME ERROR '3625'
"THE TEXT FILE SPECIFICATION 'EXPORT_CHP_TORADBILLINGSF
so, the error message says it don't exists.. did you create any export specification?
ASKER