Topshed Posted February 16, 2010 Share Posted February 16, 2010 MySQL client version: 5.0.41 Apache/1.3.37 (Unix) PHP/5.2.6 Hello, I am trying to upload an updated excel sheet to a mysql table ,but it keeps complaing about the header My Hosting company tells me that I can only upload mysql files via phpmyadmin Can anyone please point me in the right direction as to how I can achieve this, I seem to remember there was a utility I downloaded from the mySQL site that did the job but I cannot find it now Any help would be most welcome Thanks Roy... Link to comment https://forums.phpfreaks.com/topic/192217-help-needed-for-excel-to-mysql-problem/ Share on other sites More sharing options...
fenway Posted February 16, 2010 Share Posted February 16, 2010 Your mysql version has a CSV engine for this purpose. Link to comment https://forums.phpfreaks.com/topic/192217-help-needed-for-excel-to-mysql-problem/#findComment-1013150 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.