Import data from Excel. Can this be done?

[johndoomed]

Hi,

One of my clients has asked me if it is possible to import data from excel to a access table. Well, actually to a MySQL database, but my guess is that this first has to be imported into access, then exported to MySQL with an export tool.

The excel sheet contains listings for car parts. The rows (with the parts) is divided by text headings containing the different manufacturer and model. Like:

BMW
316
(rows with about 6-7 fields)
320
(rows with about 6-7 fields)
520
(rows with about 6-7 fields)
etc...

Is it possible to import this file, storing the manufacturer, model and parts in their own tables?

Or is this the complete nightmare?

Or, a combination of the two?

 

[dcobau]

you can even do it without code:

File===>Get External Data===>Import then select the exel spreadsheets you want to import

Dave

 

[johndoomed]

Thanks for you reply.

But will this know the difference between a row and a heading?

 

[boblarson]

Thanks for you reply.

But will this know the difference between a row and a heading?

Only for the first heading, where you specify which row it starts on. If the data is such that there are more headings embedded within the spreadsheet then you would either have to clean it up first by getting rid of the other headers or, if the other data should be in their own tables, you would have to iterate through the Excel data using the Excel Object Model to actually do it.