rabadaba Posted June 7, 2008 Share Posted June 7, 2008 I am working on my first PHP - My Sql website. I am just starting to get into the data development and I find it quit tedious and slow to use Php MyAdmin to enter data. Note there is no data source - I need to create and enter data from the keyboard. What would be ideal is to have some sort of editor to allow me to copy / paste etc to move data creation along quickly. My ideal set up would be to have the data in Excel, edit it and then load it to the data base. My web host service does not aloow me to upload excel files. I have had all sorts of trouble trying to upload a CSV file. Please help if there is a simple free solution. Thanks, Adi Quote Link to comment Share on other sites More sharing options...
fenway Posted June 7, 2008 Share Posted June 7, 2008 You can definitely load data in bulk from CSV... in fact, newer versions of MySQL can even using the CSV file as a storage engine. If you're having trouble, you likely haven't exported your XLS file correctly, or your LOAD DATA INFILE statement is wrong. Post the relevant info. 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.