Export Data from Access to a CSV File [VBA Programming]

preview_player
Показать описание
In this video, I show you how I export data from an Access database to a CSV file using a form to filter the data and select the path to save the file to. I also use a value from the form in the name of the saved file for further efficiency.

Рекомендации по теме
Комментарии
Автор

I appreciate your video, I find it informative and easy to follow.

I did as you explained but I get an error (3441) when trying to export my query to a CSV file.

Do you have any suggestion to resolve the problem? I am using Access 2007.

PietViljoen-xn
Автор

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

BlessonVarghese
Автор

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!

chicagobassplayer
Автор

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!

dreamsmol
Автор

my export file missing column name. Could you please help

ThuyLe-buce
Автор

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

TierraSurNow
visit shbcf.ru