therocco2k Posted March 9, 2007 Share Posted March 9, 2007 I have a Excel sheet, you can save this sheet as a wide range of extensions, the main one being .xls, but you can also do .txt tab delimited , html, .cvs, etc.... I'm very new to PHP and SQL. I'm trying to grab several columns of values, with like 200 rows. Each Column is labeled say - Model - Manufacturer - Name - Item # - Serial # etc... with each row under it displaying the info for that item. Is there any way I can take that excel sheet and import it into the MySQL database or PHP?? I'm very new, so a very detailed explanation would be of GREAT assistance. Thank you allot in advanced, this will save me 3 hours of work for something that might be done in 10 minutes. Link to comment https://forums.phpfreaks.com/topic/41910-excel-file-imported-into-mysql-or-php/ Share on other sites More sharing options...
benjaminbeazy Posted March 9, 2007 Share Posted March 9, 2007 if you have access to phpmyadmin, there's a real simple import tool to take care of it if not, check out: http://www.modwest.com/help/kb6-253.html Link to comment https://forums.phpfreaks.com/topic/41910-excel-file-imported-into-mysql-or-php/#findComment-203210 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.