By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,399 Members | 1,028 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,399 IT Pros & Developers. It's quick & easy.

Importing Records from Excel

P: n/a
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
Dec 3 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

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

Dec 3 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.