EXport MDB to CSV

[Mari]

I have more than 4000 access(.accdb) files on my server. i have to export each file to separate CSV file. Is there anyway to export into CSV without manual effort(doing one by one)

 

[isladogs]

You can't export an Access file to CSV.
Do you mean export all the tables in each file to CSV?

BTW Welcome to AWF

 

[moke123]

cross posted https://www.accessforums.net/showthread.php?t=78390

 

[jdraw]

Not sure what you mean exactly by mdb to csv. As Colin said you can't simply convert accdb to csv.
To export each object with each database to text as a csv file, see this material from ghudson.

However, I note this is your post #1 - so before doing anything, tell us what you are trying to achieve in simple terms.There may be options.

Also, welcome to the forum.

 

[Mari]

You can't export an Access file to CSV.
Do you mean export all the tables in each file to CSV?

BTW Welcome to AWF

Yes you are right. i have multiples files and i have to export the tables present in each file to CSV.

I do see a link in the response below - this material from ghudson.

But i guess this will export the tables from only one file. please correct me if i am wrong. Thanks for your response.

 

[Mari]

Thanks for your help to help with the code. I have around 3500-4000 Access DB. I can put all these DB's in one folder. I have to loop through all the DB's to convert that into CSV file. I think that is not covered here. Will you able to help with that.

Thanks again.

 

[arnelgp]

here you may try, I just made this.
if there were errors, please post back.

 

[Mari]

Thank you so much !!! It works perfect. You made my day.

Thanks everyone for the help

 

[arnelgp]

you're welcome!

 

[Gasman]

I have around 3500-4000 Access DB.

I'm still trying to get my head around this.