[tpm] Exporting Access files to .csv

[Chris Jones]

Thank you.

I have written a perl script using DBI ADO.  The 
select and print statements work.  I am using the 
join statement to separate the fields by ',' but 
I can't figure out a way to get the text fields 
quoted so the output resembles the CSV output by msaccess.

Example output from access:
240,10,"SPACE:LGT-W/A[1]","if( Local( ZONE-TYPE ) 
== 1 then 1 endif","Set lighting power","8.4.4.6","db 2012-04-19 - added",1,0

The field types:
number, number, text, memo, text, text, memo, integer, integer.

The output from my script:

240,10,SPACE:LGT-W/A[1],if( Local( ZONE-TYPE ) == 
1 then 1 endif,Set lighting power,8.4.4.6,db 2012-04-19 - added,1,0

Thanks for any insight!


At 10:04 AM 05/10/2012, Shlomi Fish wrote:
>Hi Chris,
>
>On Fri, 05 Oct 2012 08:42:30 -0400
>Chris Jones <cj at enersave.ca> wrote:
>
> > I am working on a project that uses Access to store the rule
> > sets.  It is hard to explain but a rule is a programming
> > statement.  A statement  can do one of two things: return a variable
> > or do an action.  Then the rules compiler sifts through all the
> > access files and "compiles" the rules to a binary library.
> >
> > I find it helpful to export all the tables to .csv so I can do
> > "search in files" to track the logic of the others on project.  It's
> > a nightmare but that's another story.
> >
> > So I am wondering if anyone has any ideas as to the simplest way to
> > automate the exporting of access files to .csv?
> >
>
>See the replies here:
>
>http://stackoverflow.com/questions/280894/automatically-convert-access-db
>
>Regards,
>
>         Shlomi Fish
>
>--
>-----------------------------------------------------------------
>Shlomi Fish       http://www.shlomifish.org/
>What Makes Software Apps High Quality -  http://shlom.in/sw-quality
>
>An apple a day keeps the doctor away.
>Two apples a day will keep two doctors away.
>     — one of Shlomi Fish’s relatives
>Please reply to list if it's a mailing list post - http://shlom.in/reply .

 >>
Christopher Jones, P.Eng.
Suite 1801, 1 Yonge Street
Toronto, ON M5E1W7
Tel. 416-203-7465
Fax. 416-946-1005
email cj at enersave.ca