View Full Version : How to insert a lot of values(in wrong form) in database

12-15-2011, 01:44 PM
Has anyone an Idea how I could convert or something this format so I could insert it into a database:

Id, Firstname, Lastname
1, John, Smith
2, Charles, Williams

I've no idea how I should do this.

12-15-2011, 02:37 PM
look up LOAD DATA INFILE in the manual.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum