[advanced search]
Results from the most recent live auction are here.
21 members in the live chat room. Join Chat!
Register Rules & FAQ NP$ Store Active Threads Mark Forums Read
Go Back   NamePros.Com > Design and Development > Programming
Reload this Page Converting spreadsheet to database?
User Name
Password

Old 04-14-2006, 04:06 PM   · #1
unknowngiver
Senior Member
 
Name: Zubair
Location: Ontario Canada
Trader Rating: (53)
Join Date: May 2005
Posts: 2,754
NP$: 724.15 (Donate)
unknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to all
Converting spreadsheet to database?
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


Please register or log-in into NamePros to hide ads
unknowngiver is offline   Reply With Quote
Old 04-14-2006, 04:11 PM   · #2
Flubber
NamePros Regular
 
Flubber's Avatar
 
Name: 'Flubb'
Location: Swindon, UK
Trader Rating: (49)
Join Date: Jun 2005
Posts: 691
NP$: 0.95 (Donate)
Flubber is a splendid one to beholdFlubber is a splendid one to beholdFlubber is a splendid one to beholdFlubber is a splendid one to beholdFlubber is a splendid one to beholdFlubber is a splendid one to beholdFlubber is a splendid one to beholdFlubber is a splendid one to behold
Baby Health
Never used one myself, however a google search http://www.google.com/search?source...to+mysql+export

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

Flubb
Flubber is offline   Reply With Quote
Old 04-15-2006, 01:06 AM   · #3
Palyriot
NamePros Regular
 
Palyriot's Avatar
 
Name: Derek
Location: Seattle, Wa
Trader Rating: (14)
Join Date: Jul 2004
Posts: 597
NP$: 69.00 (Donate)
Palyriot is a jewel in the roughPalyriot is a jewel in the roughPalyriot is a jewel in the rough
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...
Palyriot is offline   Reply With Quote
Old 04-15-2006, 01:10 AM   · #4
weblord
www.1weblord.com
 
weblord's Avatar
 
Name: William R. Nabaza - williamrnabaza.com
Location: Philippines - www.Nabaza.com
Trader Rating: (244)
Join Date: Dec 2005
Posts: 21,398
NP$: 21635.83 (Donate)
weblord Has achieved greatnessweblord Has achieved greatnessweblord Has achieved greatnessweblord Has achieved greatnessweblord Has achieved greatnessweblord Has achieved greatnessweblord Has achieved greatnessweblord Has achieved greatnessweblord Has achieved greatnessweblord Has achieved greatnessweblord Has achieved greatness
Autism Protect Our Planet
you can save it as .csv file and then import to mysql
Originally Posted by 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

__________________
★★★ ESTIBOT.COM Free Domain Appraisal, Keyword Tools, Available Domains ★★★
PHP Link Directory Script phpLD Templates Category Dump
♥♥Clean Toolbar♥♥
I DNKitchen.com and Chef Patrick ---> Domain News
weblord is offline  
  Reply With Quote
Old 04-15-2006, 05:50 AM   · #5
unknowngiver
Senior Member
 
Name: Zubair
Location: Ontario Canada
Trader Rating: (53)
Join Date: May 2005
Posts: 2,754
NP$: 724.15 (Donate)
unknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to all
I got this error:
Quote:
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
unknowngiver is offline   Reply With Quote
Old 04-15-2006, 12:01 PM   · #6
superprogrammer
Senior Member
 
superprogrammer's Avatar
 
Name: San
Location: Washington
Trader Rating: (84)
Join Date: Aug 2004
Posts: 4,310
NP$: 405.13 (Donate)
superprogrammer has much to be proud ofsuperprogrammer has much to be proud ofsuperprogrammer has much to be proud ofsuperprogrammer has much to be proud ofsuperprogrammer has much to be proud ofsuperprogrammer has much to be proud ofsuperprogrammer has much to be proud ofsuperprogrammer has much to be proud of
How did you try it?
__________________
Download youtube videos at www.HugYouTube.com and free domains list atwww.FreeDroplists.com
Anonymous access at www.Banned.net
superprogrammer is offline   Reply With Quote
Old 04-16-2006, 10:10 PM   · #7
unknowngiver
Senior Member
 
Name: Zubair
Location: Ontario Canada
Trader Rating: (53)
Join Date: May 2005
Posts: 2,754
NP$: 724.15 (Donate)
unknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to all
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 is offline   Reply With Quote
Old 04-17-2006, 08:06 PM   · #8
unknowngiver
Senior Member
 
Name: Zubair
Location: Ontario Canada
Trader Rating: (53)
Join Date: May 2005
Posts: 2,754
NP$: 724.15 (Donate)
unknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to all
anyoneeee?????????
unknowngiver is offline   Reply With Quote
Old 04-17-2006, 10:46 PM   · #9
hozt
NamePros Member
 
hozt's Avatar
 
Trader Rating: (36)
Join Date: May 2005
Posts: 153
NP$: 439.01 (Donate)
hozt is just really nicehozt is just really nicehozt is just really nicehozt is just really nice
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 '|';
hozt is offline   Reply With Quote
Old 04-18-2006, 04:03 PM   · #10
unknowngiver
Senior Member
 
Name: Zubair
Location: Ontario Canada
Trader Rating: (53)
Join Date: May 2005
Posts: 2,754
NP$: 724.15 (Donate)
unknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to allunknowngiver is a name known to all
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...
unknowngiver is offline   Reply With Quote
Old 04-18-2006, 07:51 PM   · #11
hozt
NamePros Member
 
hozt's Avatar
 
Trader Rating: (36)
Join Date: May 2005
Posts: 153
NP$: 439.01 (Donate)
hozt is just really nicehozt is just really nicehozt is just really nicehozt is just really nice
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.
hozt is offline   Reply With Quote
Closed Thread

NamePros is a revenue sharing forum.
« Suggest a good forum software | Any Domain Seller scripts ?? »

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


Site Sponsors
Website Header Design RealTechNetwork Website Header Design
Advertise your business at NamePros
All times are GMT -7. The time now is 10:12 AM.

Advertise At NamePros - Contact Us - NamePros.Com - Archive -Privacy Statement -Top

Powered by: vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0