You'll need to go through a multi-step process to fully move your data from
EXCEL to ACCESS.
You should import the data into ACCESS "as is" into a holding table.
Create the final table structure that you want for the database.
Then use various append queries to begin distributing the data from the
"holding" table into the permanent tables, beginning with the parent (the
"one" side of the planned "one-to-many" relationships) tables and then
moving into the children (the "many" side) tables.
It will take some planning (best to do this on paper with pencil and an
eraser!) before you start, as you will need to ensure that you can establish
the necessary relationships.

Signature
Ken Snell
<MS ACCESS MVP>
> My excel flat database is getting out of hand and really
> needs to be exported into access. (Should have done it
[quoted text clipped - 11 lines]
> employee for each recurring asset. Hope this isn't too
> confusing. Any help is greatly appreciated.
Thanks for your suggestion. Yes, it will take some
planning and patience.
>-----Original Message-----
>You'll need to go through a multi-step process to fully move your data from
[quoted text clipped - 30 lines]
>
>.