Need Help! Year / Make /Model Database ( Have Data)

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
raskal
Forum Newbie
Posts: 2
Joined: Wed Aug 19, 2009 1:38 pm

Need Help! Year / Make /Model Database ( Have Data)

Post by raskal »

Hello Everyone!

here is my issue. we have all seen the Year/Make/Model drop down boxes on countless websites. I have to get together a simple form (drop down) such as that that will point the user to a page listing all the products the company offers. I already have the data in excel and access. Currently the company uses Cold fusion but i would like to import it into a mysql database. I have read how to import from excel directly into the Sql database but that's where im stuck. Could anyone offer me any direction?

Much appreciated


Travis
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: Need Help! Year / Make /Model Database ( Have Data)

Post by califdon »

Since an Excel file is in comma delimited format, you should be able to use the MySQL command LOAD DATA INFILE LOCAL, if you have access to the MySQL command line. See http://www.modwest.com/help/kb.phtml?qid=253&cat=6. You may be able to use an Import Data function from whatever admin control panel you may have access to.
Mark Baker
Forum Regular
Posts: 710
Joined: Thu Oct 30, 2008 6:24 pm

Re: Need Help! Year / Make /Model Database ( Have Data)

Post by Mark Baker »

califdon wrote:Since an Excel file is in comma delimited format
I hate to disagree, but an Excel file is not a comma delimited file: it's actually a proprietary binary format, or an XML document, depending on what version of Excel it was created in. However, it can be exported from Excel as a CSV.
raskal
Forum Newbie
Posts: 2
Joined: Wed Aug 19, 2009 1:38 pm

Re: Need Help! Year / Make /Model Database ( Have Data)

Post by raskal »

Whats the best way to get this in GUI form is more the issue. Just a simple drop down would be ideal
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: Need Help! Year / Make /Model Database ( Have Data)

Post by califdon »

Mark Baker wrote:
califdon wrote:Since an Excel file is in comma delimited format
I hate to disagree, but an Excel file is not a comma delimited file: it's actually a proprietary binary format, or an XML document, depending on what version of Excel it was created in. However, it can be exported from Excel as a CSV.
I guess you're right, I wasn't thinking very clearly, Excel can read CSV files, but its own format is not CSV. But yes, it's simple to export if from Excel as a CSV file. Thanks for catching that, Mark.
Mark Baker
Forum Regular
Posts: 710
Joined: Thu Oct 30, 2008 6:24 pm

Re: Need Help! Year / Make /Model Database ( Have Data)

Post by Mark Baker »

raskal wrote:Whats the best way to get this in GUI form is more the issue. Just a simple drop down would be ideal
Have you already transferred the data from Excel into MySQL? If so, there's plenty of tutorials and examples for creating a drop-down from data in MySQL.
If you still need to transfer the data from Excel to MySQL, then we need at least some information on your MySQL tables and the layout of your spreadsheets if we're to provide any help.
Post Reply