[NMLUG] MS Access -> MySQL

[jlindsey at 3drc.com (Jonathan Lindsey)]

I have several years of PHP experience as well as MySQL administration.  I
do not have the time to develop what you need, but if you have any questions
feel free to ask.  I'd be more than happy to help.

-Jonathan Lindsey
Network Engineer
3D Research Corporation



-----Original Message-----
From: nmlug-bounces at nmlug.org [mailto:nmlug-bounces at nmlug.org] On Behalf Of
J. Marsden DeLapp
Sent: Thursday, November 29, 2007 11:01 PM
To: New Mexico Linux Users Group Mail List
Subject: Re: [NMLUG] MS Access -> MySQL

Tim Price wrote:
> I found the easiest way to convert Access files to MySQL is to write out 
> the Access files as text or csv files, create the tables with the same 
> structure in MySQL, and use the load data local infile command to load 
> the text or csv files into Mysql.  I've seen some Access to MySQL 
> scripts, but they looked more complicated then the process I use. Also, 
> if your Access tables have less then 65K rows of data, you can bring 
> them into MS Excel to use as a check on the data load.

I kind of figured that would be the direction to go. Build a nice new clean
DB in MySQL then load the proper data, 
leaving behind all the junk, useless stuff and some design errors in the old
Access DB.

Using one of those conversion tools is likely to carry forward too much
junk.

Mars

-- 
=============================================================
J. Marsden DeLapp, PE
President
DeLapp & Associates, Inc. dba DeLapp EngineeringR
Providing lighting and power planning, design and analysis services
for commercial, industrial and large residential facilities.
1190 Harrison Rd Ste 3a
Santa Fe NM 87507
(505) 983-5557
http://DeLapp.com
=============================================================

_______________________________________________
NMLUG mailing list
NMLUG at nmlug.org
http://lists.b9.com/cgi-bin/mailman/listinfo/nmlug
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3280 bytes
Desc: not available
Url : http://lists.b9.com/pipermail/nmlug/attachments/20071130/3384713e/attachment.bin