Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / September 2004

Tip: Looking for answers? Try searching our database.

Import from excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
- 01 Sep 2004 14:10 GMT
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.
Ken Snell [MVP] - 01 Sep 2004 15:25 GMT
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.
- 02 Sep 2004 04:03 GMT
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]
>
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.