Can a query do ...

[Guest]

Hello

I have just imported a masive excel spreadsheet into access. I need to transfer this information into the related tables

For instance, In the excel table I have fields ID, Name, Description, Impacted Drawing. However, in the access database the Impacted Drawing field in is a sepearate table and is linked to the main table by an Autonumber. How can I populate all of the table to that I don't loose the links

Basically I need to transfer info into a multitude of tables (5 different table in all) and ensure that for each entry it associate the proper entry Id number (autonumber from the first main table

I hope you could follow the issue ... it isn't easy to explain with just text (I which I could insert diagrams into these messages)

Thanks

Daniel

 

[John Viescas]

Daniel-

Try selecting the imported table and choose Tools / Analyze / Table. In
the window that asks you whether you want the Wizard to decide what fields
go in which tables, choose NO. You'll see a graphical interface next where
you can drag and drop fields from your original tables to create new ones.
The Wizard will create Autonumber keys and leave a linking field back in the
original table. It's a great way to "normalize" a data structure from an
unnormalized set of data imported from Excel.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)

Hello,

I have just imported a masive excel spreadsheet into access. I need to

transfer this information into the related tables.

For instance, In the excel table I have fields ID, Name, Description,

Impacted Drawing. However, in the access database the Impacted Drawing
field in is a sepearate table and is linked to the main table by an
Autonumber. How can I populate all of the table to that I don't loose the
links.

Basically I need to transfer info into a multitude of tables (5 different

table in all) and ensure that for each entry it associate the proper entry
Id number (autonumber from the first main table)

I hope you could follow the issue ... it isn't easy to explain with just

text (I which I could insert diagrams into these messages).