• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 459
  • Last Modified:

Convert an Excel Spreadsheet into a Mysql table

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

can anyone help?

thanks
0
Jonesey007
Asked:
Jonesey007
1 Solution
 
ScannyRCommented:
The easiest way would probably be to save the excel file as a csv file and that can then be imported into MySQL. You will have to make sure the structure and order of the csv file matches the database table though so I would suggest first saving a copy of the spreadsheet, then deleting surplus columns and adjusting the order of remaining columns. You can then save this trimmed down version as a CSV file and import it into MySQL.

Rich
0

Featured Post

Hire Technology Freelancers with Gigs

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now