Inputting Large Amounts Of Data

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Rozzy85
Forum Newbie
Posts: 7
Joined: Wed Feb 13, 2008 10:37 am

Inputting Large Amounts Of Data

Post by Rozzy85 »

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.
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: Inputting Large Amounts Of Data

Post by califdon »

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.
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:
http://www.modwest.com/help/kb6-253.html
Rozzy85
Forum Newbie
Posts: 7
Joined: Wed Feb 13, 2008 10:37 am

Re: Inputting Large Amounts Of Data

Post by Rozzy85 »

I didn't know you could import data directly like that. I thought you could only do it with a third party application.

Thanks!
Post Reply