Excel Import / Referential Integrity Question

[Ray Todd Jr]

I have created a new database. The data in the 'flat' database of the Excel
spreadsheet doesn't match the fields in the database, i.e., we are collecting
more information in the database than what was being captured via the
spreadsheet.
The Database consisist of 5 tables.

My question is this. How do I import the approximately 600 records
contained in the Excel spreadsheet, sorting those records among the various
tables while keeping the data correctly linked?

Thanks,

Ray.

 

[Douglas J. Steele]

Link to the Excel spreadsheet.

Write queries to update your actual tables from that linked spreadsheet.

 

[Peter Hibbs]

Ray,

If this is a 'one off' operation then maybe the Excel to Access
Converter Utility program at :-
http://www.rogersaccesslibrary.com/...p?FID=21&SID=5debzz2c87c6957859f13b1d2zcccfb4
will do that for you.

HTH

Peter Hibbs.

 

[RayToddJr]

Hello Peter:

Thanks for the suggestion.

I had already downloaded this problem. The only problem that I saw in what
I am trying to do is that I *already* have my tables laid out and need to
move the data from the spreadsheet to the new tables. This program would be
great to create tables using the existing data.

Do I have a misunderstanding/misconception?

Thanks,

Ray.

 

[RayToddJr]

Douglas:

I guess I have to admit that simply don't have a clear understanding of how
to do this properly?

I understand how to update the tables using queries. I guess the problem
that I can't wrap my mind around is this, I simply don't know how to keep the
records linked.

Thanks,

Ray.

 

[Peter Hibbs]

Ray,

I think you do. The documentation does say that you should create the
tables before importing the data (although you can have the option of
letting Access create the tables automatically). The only thing you
need to be aware of is that you should not link the tables together
using AutoNumber type fields as Primary Keys (not a good idea in my
opinion anyway) as the program does all that for you. Perhaps you
should have a look at the notes again, it sounds like the program can
do what you want although it does take a bit of thought.

Peter Hibbs.

 

[RayToddJr]

Hello Peter:

I will re-read the documentation more clearly/slowly this time.

Thanks,

Ray.

 

[RayToddJr]

Peter:

You are absolutely correct. I should have read the instructions much more
carefully than I did.

The data has been converted succesfully and correctly.

Thanks,

Ray.

 

[Peter Hibbs]

Ray,

Excellent, glad to be of help.

Peter.

Peter:

You are absolutely correct. I should have read the instructions much more
carefully than I did.

The data has been converted succesfully and correctly.

Thanks,

Ray.