Importing Records from Excel

[OM]

I have a database table, which is linked to a second table. I have some data
in Excel tables, but the data is in 1 spreadsheet, and needs to go into 2
tables, and keep the relationships intact.

The 2 tables are tblEmployees (which holds employee data), and the related
table is tblEndOfMonth, (which holds KPI's against the Employees). The
spreadsheet has this data in 1 table. How do I spilt this data when I import
it, and get the relationships correct ?

Thanks wise gurus,

Rob Lepper

[pietlinden]

OM wrote:

I have a database table, which is linked to a second table. I have some data
in Excel tables, but the data is in 1 spreadsheet, and needs to go into 2
tables, and keep the relationships intact.

The 2 tables are tblEmployees (which holds employee data), and the related
table is tblEndOfMonth, (which holds KPI's against the Employees). The
spreadsheet has this data in 1 table. How do I spilt this data when I import
it, and get the relationships correct ?

Thanks wise gurus,

Rob Lepper

Create a link to the table.
Create an append query that will put all the relevant Employees data
into tblEmployees.
Create a second append query that will put the KPI info into the
tblEndOfMonth table, and be _sure_ to include the EmployeeID. (if you
need to add one, you should probably do it in Excel first, and then
import.)

HTH