Import from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My excel flat database is getting out of hand and really
needs to be exported into access. (Should have done it
long ago). Basically what I have is a field listing
several hundred employees who are assigned various assets
each with their own field. Several assets from the same
field are assigned to the same employee and to keep the
database too large with too many fields, the employee was
listed several times. How in the world can I effectively
import into access since the records have duplicate
entries on Personnel field? Hopefully there is a work-a-
round for this. In a nutshell, when the employee had
multible assets of a particular field asset it was much
easier to just start another record listing the same
employee for each recurring asset. Hope this isn't too
confusing. Any help is greatly appreciated.
 
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.
 
Back
Top