Would it be possible to automate the creation of the CSV file from Access? Thus, I need a nightly process to run to pull down a bunch of data into CSV files. Thanks!
Thank you for this video! When I export the query, hidden fields are also coming in the excel file. How to overcome this challenge, I don't want those fields to be shown in the exported file. Please help!
I entered a date field wich reads OK in the Access query but whe exported to CSV it gives dd/mm/yyyy hhmm format also the numbers are coming as $ format.... uuurrrhhh