Export Query Result into CSV

[David Sabot]

I have a query that pulls some data from various tables. I would like it to automatically run somehow daily and take the results and put them into a CSV file in a specific directory. The CSV file should be MM-DD-YY.csv so it doesn't overwrite the existing data. Any advice on how to accomplish this?



<< NOTE >> I am sorry, I should have put this in the Import/Export thread. I don't want to crosspost. Mod can you help?

[hertfordkc]

One of the parameters provides for "Export Delimited".
You might construct the exported file name as
"C:\Somedirs\" & Date() & ".csv" (I'm not sure whether or not the file type is automatically created.)
As far as running the export daily, there are a couple of possibilities. The simplest path might be to have Windows start the database with a command line parameter specifying the maco which you want to run. Google 'access command line'
Basically it looks like this: C:\somepath\Dbname /x dumpmacro

[thhui]

Use macro to automate the export task

Something like that:-

CurrentYMD = DateSerial(Year(Date), Month(Date), Day(Date))
mmddyy=format(CurrentYMD, "mm-dd-yy")

DoCmd.TransferText acExportDelim, , mmddyy & ".csv", True