Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: exporting MS ACCESS tables into a CSV file

by ww (Archbishop)
on Jul 11, 2005 at 19:55 UTC ( #474076=note: print w/replies, xml ) Need Help??


in reply to exporting MS ACCESS tables into a CSV file

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.

  • Comment on Re: exporting MS ACCESS tables into a CSV file

Replies are listed 'Best First'.
Re^2: exporting MS ACCESS tables into a CSV file
by chicago928 (Initiate) on Jul 11, 2005 at 20:15 UTC
    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

Re^2: exporting MS ACCESS tables into a CSV file
by sparkyichi (Deacon) on Jul 11, 2005 at 20:48 UTC
    I have used perl many times to extract from DB's and put them into excel. Perl is very good at doing this.
    Sparky
    FMTEYEWTK

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://474076]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (2)
As of 2023-02-04 03:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I prefer not to run the latest version of Perl because:







    Results (30 votes). Check out past polls.

    Notices?