Results 1 to 3 of 3

Thread: How to upload or import data to MySQL

  1. 02-10-2007 #1
    mrbobolina
    mrbobolina is offline No longer a Newbie
    Join Date
    Feb 2007
    Posts
    5

    Default How to upload or import data to MySQL

    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
    Reply With Quote Reply With Quote
  2. 02-11-2007 #2
    jmarcv's Avatar
    jmarcv
    jmarcv is offline Cranky Coder
    Join Date
    Jan 2005
    Posts
    354

    Default

    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?
    Reply With Quote Reply With Quote
  3. 02-11-2007 #3
    mrbobolina
    mrbobolina is offline No longer a Newbie
    Join Date
    Feb 2007
    Posts
    5

    Default

    Thanks for the link jmarcv. I'll give it a try.
    Reply With Quote Reply With Quote
« Script for search engine results | Password protected page »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


1 2 3 4 5 6 7 8 9 10 11 12 13 14