How To Automate an Export to CSV from an Access Query
Posted on 2011-02-24
I created a query that will produce a list of only the products that have price changes in effect. The query needs to be exported to a csv file and be uploaded to an FTP site. I would like to automate the exporting of the query - so that it will be less complicated for certain individuals.
I have tried creating a module "ExportQuery with the following code:
DoCmd.TransferText acExportDelim, , "[qryPriceList]", "[NewPrices].csv"
I get an error stating it cannot find qryPriceList - and to make sure it is spelled correctly. It is spelled correctly - so I am a little lost here - any help would be greatly appreciated