Search results

Thanks for the offer; we're still trying different options. If we keep running into a brick wall, I'll get back to you.

Thanks for asking; not yet. We're still working on it as time permits. Thanks again.

Trevor, I'll be signing off in a few minutes, and will start back up in the morning... thanks for your patience....

BTW, I'm getting a Run-time error '3274': External table is not in the expected format. error when I run your last suggestion. here is what I'm trying to run: Sub trans() DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel9, "DailySilverPopEnrollmentFile", "O:\File Location Files\FILENAME_"...

What is "acSpreadsheetTypeExcel9" for? I'm exporting an Access table to a .csv file; it must be named "SDN_mmddyy.csv" - my macro is using the Import/Export Text function and the Transfer Type is Export Delimited. I hope this helps...

TransferType: Export Delimited

Thanks Trevor; I got an error message "Cannot Update - Database or Object is Read Only"... Must have done something wrong. I'm using an Export function in my macro...

I'm using Access 2003 and need to export a table to a .csv file with today's date as the last part of the file name in mmddyy format. My macro exports a table to the csv file; how do I include today's date in the file name?