SendObject Export CSV and Import CSV

[DetrieZ]

I have this code that works perfectly with XLS (Excel 2003) files, but now I need it to run CSV files

This creates and attaches the file to an email

DoCmd.SendObject acSendQuery, "OutputNewRecords", acExportDelim, , , , "New Record Data - " & Now, "Here are the latest Records", True

I've tried this but it still creates an XLS file

DoCmd.SendObject acSendQuery, "OutputNewRecords", acExportDelim, , , , "New Record Data - " & Now, "Here are the latest Records", True

This imports the files

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, strTableName, strFile, True

Am I missing something simple?

[June7]

I don't see anything different between the first two examples.

You can try specifying the output format as acFormatTXT but I don't think SendObject method allows for comma separated text file. Might have to use alternate coding to save a file and then attach the file to message. Review: http://www.wiredbox.net/Forum/Thread...om_Access.aspx

[DetrieZ]

Argh... sorry.. you're right

the working code is

DoCmd.SendObject acSendQuery, "OutputNewRecords", acFormatXLS, , ,  , "New Record Data - " & Now, "Here are the latest Records",  True

the code I tried but created an XLS file was

DoCmd.SendObject  acSendQuery, "OutputNewRecords", acExportDelim, , , , "New Record Data -  " & Now, "Here are the latest Records", True