SPUG: txt -> db
Richard Haynal
Richard.Haynal at comcast.net
Wed May 12 19:37:53 CDT 2004
I had to once do that with perl. You can use DBI and either DBD-ODBC or
DBD-ADO.
James Moore wrote:
>AFAIK, the mdb file format isn't usable from anything other than Jet itself
>(the engine that writes those things - Access is built around Jet). In the
>past MS has guarded the mdb format like a rabid dog, and since it's of
>dubious value I don't know of any non-MS attempts to read and write it
>directly. Doesn't mean they don't exist, I just don't know about 'em.
>
>Possibilities:
>
>1. Set up an ODBC driver on the Windows box that's going to run the
>database and talk to that. I've never tried to hook Perl straight up to
>odbc, but it's probably straightforward.
>
>2. (What I'd do, since #1 would require learning something new, and
>everyone knows that once you become a real estate agent your ability topi)
>Write to a mysql database which you then export via odbc to an access or a
>sql server setup. On the sqlserver side run a query to select from mysql
>into a local table. Haven't done this exactly, but I do use mysql databases
>in Access via odbc, so getting the rest of the way should be trivial (it's
>just a query once you're reading the mysql tables in Access).
>
>3. (Warning - heresy alert) Don't bother. Your target is an MS-specific
>abomination. Embrace the darkside and go with an all-MS solution.
>
>- James
>
>
>_____________________________________________________________
>Seattle Perl Users Group Mailing List
>POST TO: spug-list at mail.pm.org http://spugwiki.perlocity.org
>ACCOUNT CONFIG: http://mail.pm.org/mailman/listinfo/spug-list
>MEETINGS: 3rd Tuesdays, Location Unknown
>WEB PAGE: http://www.seattleperl.org
>
>
>
More information about the spug-list
mailing list