Converting spreadsheet to database?

[unknowngiver]

Hey
I got alot of google high paying keywords as a spreadsheet file...and i wanted to convert them to a database file and use them to make a site in php
can anyone tell me how to do that? is there a tool available to do that or something

 

[Flubber]

Never used one myself, however a google search http://www.google.com/search?source...:2005-09,GGGL:en&q=free+excel+to+mysql+export

Reveals a lot of shareware that seems to be capable of the job, yet to find a free one.

Flubb

 

[Palyriot]

can't you move an excel sheet straight to a database via phpmyadmin? I think I've done it before. Maybe it's vice versa...

 

[weblord]

you can save it as .csv file and then import to mysql

Hey
I got alot of google high paying keywords as a spreadsheet file...and i wanted to convert them to a database file and use them to make a site in php
can anyone tell me how to do that? is there a tool available to do that or something

 

[unknowngiver]

I got this error:

MySQL said: Documentation
#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 'Keywords,Top Bid,Search
austin criminal attorney,$74.02 ,379

 

[superprogrammer]

How did you try it?

 

[unknowngiver]

well i saved it as csv and i got tht error
i downloaded a software from tht link...but its a paid one and i could only get a trial one which only converts 20 records

 

[unknowngiver]

anyoneeee?????????

 

[hozt]

Save as a .csv from your spreadsheet program. I have had good luck using a pipe (|) delimeter and no quotes around the field. Once you have the export run this from the mysql terminal:
LOAD DATA INFILE 'export.csv' INTO TABLE Your_Table FIELDS TERMINATED BY '|';

 

[unknowngiver]

hm how do i add those | and no quotes..do i do tht manualy
i have abt 21,000 enteries..it will be quite hard 2 manualy add/delete stuff from each...

 

[hozt]

Just open the spreadsheet in Calc, Excel, or your spreadsheet program and do a save as .csv. There should be place where you can configure the output. Your other option is to just send the file to someone that knows how to do this. It should take less than 5 minutes to import and dump the sql.