Exporting database to CSV in one hit

[Greengecko]

I need to export a complete access database (consisting of several tables) to one CSV file.

I know it's possible to do a table at a time, but this won't give me a single CSV file - and I have 180 databases to do!

Is there a solution? Many thanks in advance.

 

[egapogi]

I don't know exactly what's your good reason you want to put it in a single csv file. But for the sake of what you want to do, here is my 2 cents.

I suppose all tables have the same field. But even if not, you can still do this.

Loop to all tables in a tabledefs and read all records in each table and print it to a txt file. Just manipulate your print statement to have the delimeter(&quot and/or separator (,); I hope you are familiar with Open.. output... and print statement... If not check your online help.

HTH,
ega