miracle_potential Posted April 30, 2008 Share Posted April 30, 2008 I have been searching for hours on how to get my Excel sheet into MYSQL but all the converters cost bloody money and the demos only do like 5 rows ¬_¬ Does anyone know how to do this? because I really need this doing there are like 350 differant rows of products for a shop I'm programming Link to comment https://forums.phpfreaks.com/topic/103573-excel-to-mysql-problems/ Share on other sites More sharing options...
micah1701 Posted April 30, 2008 Share Posted April 30, 2008 are you looking for an application that allows end users to do this on a regular basis or are you just trying to get a spreadsheet into your database? if the later is true, save the spread sheet as a comma or tab delimited CSV or TXT file in excel. Then you can upload it easily with phpMyAdmin or a few SQL commands. Link to comment https://forums.phpfreaks.com/topic/103573-excel-to-mysql-problems/#findComment-530373 Share on other sites More sharing options...
miracle_potential Posted April 30, 2008 Author Share Posted April 30, 2008 Neither file will upload, I only need to do this once its for a shop its all the products [attachment deleted by admin] Link to comment https://forums.phpfreaks.com/topic/103573-excel-to-mysql-problems/#findComment-530394 Share on other sites More sharing options...
miracle_potential Posted April 30, 2008 Author Share Posted April 30, 2008 BUMP Link to comment https://forums.phpfreaks.com/topic/103573-excel-to-mysql-problems/#findComment-530558 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.