Minggu, 04 Februari 2018

[MS_AccessPros] CSV export not working

 

I am using Access 2003 and use the following code to export to an Excel file. This code used to work fine, but no longer works.'DoCmd.TransferSpreadsheet acExport' gives me : run-time error '3274' external table is not in the expected format.



MyDocsPath = Environ$("USERPROFILE") & "\" & "My Documents\"

DoCmd.OutputTo acOutputQuery, "MLTC1b_Detail", acFormatXLS, MyDocsPath & "MLTC Summary" & Format([Forms]![mltc1]![pid from], "yyyymmdd") & ".csv", False

DoCmd.TransferSpreadsheet acExport, 8, "mltc1b_Day_summary", MyDocsPath & "MLTC Summary" & Format([Forms]![mltc1]![pid from], "yyyymmdd") & ".csv", False

DoCmd.TransferSpreadsheet acExport, 8, "mltc1b_Registrant_summary", MyDocsPath & "MLTC Summary" & Format([Forms]![mltc1]![pid from], "yyyymmdd") & ".csv", True


Maybe it is because I installed Excel 2016,  Excel 2003 is also installed in this computer. I tried changing 'acExport, 8,' to 'acExport, 9,'  and 'acExport, 10,'. I get the same error. 


Please help


Thanks 


Sarah



__._,_.___

Posted by: sarahk@schemesoftware.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Posting Komentar