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 Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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.