Being perl-centric.. my instinct would be to use Perl w/ODBC and DBD::MySQL
for the whole thing.
I realize there may be incompatibilites between 'column types', but why not
just recreate the structure (memos -> mediumtext, etc..), dump from Access
to a .csv, then load it in with mysqlimport or LOAD DATA?
BTW - there's a chance one of the many MySQL GUI's (many use GTK, or even
WinMySQL http://www.geocities.com/SiliconValley/Circuit/4105/) might help ya
----- Original Message -----
From: Paul DuBois <paul@stripped>
To: Chris Lott <chrisl@stripped>
Sent: Saturday, June 19, 1999 12:04 PM
Subject: Re: Storing HTML text
> At 8:03 AM -0800 6/19/1999, Chris Lott wrote:
> >> Since you are (apparently) going to be using a script to retrieve your
> >> data and generate the HTML pages, why don't you also use a script to
> >> read your data and insert it in the first place? There's no reason
> >> you have to use LOAD DATA to put in your data.
> >I'm going to use PHP to build the pages and retrieve the data. I can use
> >to insert the data... but I am looking for a way to convert a large
> >of legacy data that has been, up to now, stored in Microsoft Access db's
> >using a combination of fields including memo fields for the pages of
> >My first thought was to dump them into some delimited format and import
> >via LOAD DATA, but this fails because of the variable length of the memo
> >I will look into using PHP to read the files and insert the data... or
> >perhaps find a Perl guru to help do something if that is the direction I
> >have to take.
> Yes, for a problem like that, you might find a standalone program
> written using Perl and DBI a better solution than PHP. PHP can be
> used for standalone programs, but it's really more suitable for a Web
> Other readers of the list may have different views - I'd be interested
> to hear other suggestions.
> Paul DuBois, paul@stripped
> Northern League Chronicles: http://www.snake.net/nl/
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread5485@stripped
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.