stvchez Posted March 19, 2007 Share Posted March 19, 2007 I have site for a client that I've been working on. anyways, they have a master signup speadsheet, it gets progressively updated, and they send it to over me. I full by doing an SQL import of that csv file. I've now down this mysql update 10 times, and wonder if there is another solution. Basically, I just need an easy way, be it an upload form, or whatever, for them to easily transfer their excel updates. thanks Link to comment https://forums.phpfreaks.com/topic/43376-excel-to-mysql/ Share on other sites More sharing options...
artacus Posted March 19, 2007 Share Posted March 19, 2007 Well the only way you are going to be able to automate it is by getting them to upload a csv instead of excel. Link to comment https://forums.phpfreaks.com/topic/43376-excel-to-mysql/#findComment-210708 Share on other sites More sharing options...
fenway Posted March 20, 2007 Share Posted March 20, 2007 Correct -- just save as tab delimited from excel, and you should be fine with a LOAD DATA INFILE. Link to comment https://forums.phpfreaks.com/topic/43376-excel-to-mysql/#findComment-211285 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.