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!
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!
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
Super helpful, thank you!
sir, i like your videos and the way you explain things. it would be great if you make a video on converting data of an SFM file into CSV
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!
Easy way and good explanation
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!
That would require something outside the scope of VBA. Like robotic process automation or maybe a scheduled VB script with Windows scheduler.
Couldn't you do this same thing but put on the timer event?
my export file missing column name. Could you please help
Is your FieldName argument in DoCmd.TransferText set to True? (7:18)
Muy bueno
How can i do this to PDF
HOW DO U DELETE THE DATA
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