Re: exporting MS ACCESS tables into a CSV file

[ww]

This becomes a non-perl question if you export the access data to excel which you can then export to csv.

shiza is correct about direct export from access... but it (vers. 8.0.0.4122) does NOT include csv as a direct option. Hence, the above using excel as an intermediary.

[chicago928]

I would know how to export to .csv for any one of the tables. Unfortunately, I anticipate having several hundred files each with perhaps 15-20 tables.

So if i had a generic file, "foo.mdb" and wanted to export all of its tables (I won't know these in advance). Is there an easy way to do this in perl?

Thanks

[sparkyichi]

I have used perl many times to extract from DB's and put them into excel. Perl is very good at doing this.