Excel database to Mysql
Hi,
Apparently my thread was forgotten and nobody from WebAssist replied.
I posted my topic in 3/12/2010 and I asked for support but nobday shows up.
Why? Is it something wrong with what I am saying here about your eCart advertising?...:confused:
Nevermind, you can maybe help me about Database Import to Mysql.
I gave a try to make my database with the Excel program that I have in my computer and I did some research on Google and I found out that we can import excel database(save as .csv file format) to phpMyadmin Mysql.
I save my Excel DB as .csv and try to import in phpMyadmin Mysql but I get the Error Message below:
#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 'ProductID,ProductName,ProductCategoryID,ProductPrice RW004,DIA .75CT 18KT/WG,Eng' at line 1.
What could be the reason?
I just let you know that I tried to install MySQL GUI tools for importing myDB to Mysql but it failed in installation.
According to Mysql website, it is not supported for my OS (Mac OSX 10.4.11 PowerPC G5).
See the link:
eol-notice.html
Any help would be appreciated.
Regards.