Inputting Large Amounts Of Data
Moderator: General Moderators
Inputting Large Amounts Of Data
I need to input large amounts of data into my database. Inserting all this manually through the command console doesn't seem pratical and would take ages to do and probably result in errors from typos etc. I found that they're are Excel 2 MySQL converters but I can only find Shareware versions and there seem to be no free versions available. I did find a free one but all the links to download it were dead. Is this the only pratical method to do it or are there better ways? If the worst comes to the worst I'll just create a form in HTML to insert the data into the database that way.
Re: Inputting Large Amounts Of Data
You're saying that the data is already in Excel? Make sure the columns are in synch with the fields in your table, save it from Excel as CSV (comma separated values), then import it into MySQL using the LOAD DATA LOCAL INFILE syntax:Rozzy85 wrote:I need to input large amounts of data into my database. Inserting all this manually through the command console doesn't seem pratical and would take ages to do and probably result in errors from typos etc. I found that they're are Excel 2 MySQL converters but I can only find Shareware versions and there seem to be no free versions available. I did find a free one but all the links to download it were dead. Is this the only pratical method to do it or are there better ways? If the worst comes to the worst I'll just create a form in HTML to insert the data into the database that way.
http://www.modwest.com/help/kb6-253.html
Re: Inputting Large Amounts Of Data
I didn't know you could import data directly like that. I thought you could only do it with a third party application.
Thanks!
Thanks!