How to upload or import data to MySQL

mrbobolina · #1 (**permalink**) 02-10-2007

What's the best way to upload excel data to the MYSQL database? I've tried importing from the database but get the error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<HTML>
<HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html;CHARSET=ISO-885' at line 1

Any thoughts...suggestions?

Thanks

jmarcv · #2 (**permalink**) 02-11-2007

How did you import? Looks to me like you just duimped a web page somewhere. You need to save as a csv and massage the data. But it sounds like you need a more automatic solution. There are a number of companies that have software.

I think this one might be free.

http://www.stardeveloper.com/article...3101901&page=1

Anyone out there have a script?

mrbobolina · #3 (**permalink**) 02-11-2007

Thanks for the link jmarcv. I'll give it a try.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode