Re: MS Access -> MySQL

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.

On Nov 29, 2007, at 10:07 PM, Brian Rodgers wrote:

> I can't help with the data base but I do applaud you for helping  
> out the NMSEA
>
>
> On Nov 29, 2007 10:01 PM, J. Marsden DeLapp <[email protected] >  
> wrote:
> I am looking for some help with some database conversion and web  
> programming tasks.
>
> One of the tasks is converting a MS access database to MySQL and  
> some sort of user interface that runs on Gnu/Linux. I
> was thinking maybe Knoda for the frontend or maybe do it with PHP.  
> I currently use this database in my business to
> manage projects, time sheets, expenses and billing.
>
> The second task is building a web based database for the New Mexico  
> Solar Energy Association (NMSEA) http://nmsea.org
> This would include a database to track members, vendors and all  
> kinds of stuff.
>
> Anyone got experience and/or a strong desire to learn?
>
> 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
>
>
>
> -- 
> Brian Rodgers
> All Internet traffic from Las Tusas Ranch relayed through DIY solar  
> powered WiFi tower.
> View the tower here: http://www.outfitnm.com/HTML/wifi.html
> _______________________________________________
> NMLUG mailing list
> [email protected]
> http://lists.b9.com/cgi-bin/mailman/listinfo/nmlug

__
Tim Price
Director, Information Technology
Architectural Research Consultants, Incorporated
505-842-1254

_______________________________________________
NMLUG mailing list
[email protected]
http://lists.b9.com/cgi-bin/mailman/listinfo/nmlug