Subject: Re: ms access,openoffice and mysql
From: Arthur Corliss (arthur@corlissfamily.org)
Date: Mon Feb 03 2003 - 07:56:26 AKST
On Mon, 3 Feb 2003, Mehran wrote:
>
> Tim;
> I am still working on it. I've saved Excel file as
> .cvs and import them to a text editor, it works , but
> its very time consuming.
Wouldn't it be simpler to use a Perl script with a DBI and a module like
Text::CSV? Load the CSV file and use a prepared paramterised query to push
each record into the target DB.
--Arthur Corliss
Bolverk's Lair -- http://arthur.corlissfamily.org/
Digital Mages -- http://www.digitalmages.com/
"Live Free or Die, the Only Way to Live" -- NH State Motto
---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
This archive was generated by hypermail 2a23 : Mon Feb 03 2003 - 08:27:07 AKST