Results 1 to 3 of 3

Thread: How to upload or import data to MySQL

  1. #1
    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

  2. #2
    jmarcv's Avatar
    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?

  3. #3
    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.

Bookmarks

Posting Permissions

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

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