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... Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.