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
Need Help! Year / Make /Model Database ( Have Data)
Moderator: General Moderators
Re: Need Help! Year / Make /Model Database ( Have Data)
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)
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.califdon wrote:Since an Excel file is in comma delimited format
Re: Need Help! Year / Make /Model Database ( Have Data)
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)
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 wrote: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.califdon wrote:Since an Excel file is in comma delimited format
-
Mark Baker
- Forum Regular
- Posts: 710
- Joined: Thu Oct 30, 2008 6:24 pm
Re: Need Help! Year / Make /Model Database ( Have Data)
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.raskal wrote:Whats the best way to get this in GUI form is more the issue. Just a simple drop down would be ideal
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.