Re: MS Access -> MySQL
"J. Marsden DeLapp" <[email protected]>
| Newsgroups | gmane.org.user-groups.nmlug |
|---|---|
| Message-ID | <[email protected]> |
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 Engineering® 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 [email protected] http://lists.b9.com/cgi-bin/mailman/listinfo/nmlug