Page 1 of 1
Need Help! Year / Make /Model Database ( Have Data)
Posted: Wed Aug 19, 2009 1:42 pm
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
Re: Need Help! Year / Make /Model Database ( Have Data)
Posted: Wed Aug 19, 2009 3:20 pm
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.
Re: Need Help! Year / Make /Model Database ( Have Data)
Posted: Thu Aug 20, 2009 7:31 am
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.
Re: Need Help! Year / Make /Model Database ( Have Data)
Posted: Thu Aug 20, 2009 8:45 am
by raskal
Whats the best way to get this in GUI form is more the issue. Just a simple drop down would be ideal
Re: Need Help! Year / Make /Model Database ( Have Data)
Posted: Thu Aug 20, 2009 1:27 pm
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.
Re: Need Help! Year / Make /Model Database ( Have Data)
Posted: Fri Aug 21, 2009 5:02 am
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.