Import Data from Excel to Relational Tables

[karl009]

Hi,
I have a database with two tables joined with a One-to-Many relationship, how would you import records over the two tables from one sheet.

The sheet will have the enquiry detail which is one table and then the lines of the enquiry the other table.

I have red up that an INSERT query can be used but am unsure where to begin with that.

Here is an example of the spreadsheet.

Thanks for any help...
Karl

 

[JamesMcS]

If it was me I'd import the spreadsheet into one table, then do a couple of append queries (that's the INSERT INTO bit) to get the data you want in the other tables.

 

[DCrake]

Another method would be to define named ranges in your spreadsheet and use these ranges to import into different tables in Access.

 

[karl009]

Thanks to both of you for your replies...

The named ranges where a good idea and worked well...

Many Thanks