Hi, can anyone give me any advice on a way to do this. Ive got an old excel spreadsheet with 500 records in it that id like to put into an 'assets' table in a mysql database. I've had a look on the net and can find straight forward 1:1 conversions but the problem is the number of columns has halfed in the new database so i could like to map the data in the excel spreadsheet into the columns in the database and want to ignore the data in the excel columns we dont need anymore
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.