Appending to normalized split tables

[Guest]

I may not be using the right terminology ...

Imported an XLS (table > import) and ran Table Analyzer Wizard, which split
the one (pre-normalized) table into two. The two resulting tables didn't
exist before and were created as part of this process.

Question: I appreciate the Wizard split up the one table for me, but if I
have a bunch of other XLSs (in the exact same pre-normalized format), how can
I append the rest of my data into these two new tables? The Wizard only seems
willing to do the normalization into two tables that didn't previously exist.

Insight appreciated. Thanks.

 

[Guest]

On importing, uncheck the checkbox that says to use the Analyser wizard.

-Dorian

 

[John W. Vinson]

On Wed, 21 Nov 2007 08:53:01 -0800, Grand Pappy <Grand

I may not be using the right terminology ...

Imported an XLS (table > import) and ran Table Analyzer Wizard, which split
the one (pre-normalized) table into two. The two resulting tables didn't
exist before and were created as part of this process.

Question: I appreciate the Wizard split up the one table for me, but if I
have a bunch of other XLSs (in the exact same pre-normalized format), how can
I append the rest of my data into these two new tables? The Wizard only seems
willing to do the normalization into two tables that didn't previously exist.

Insight appreciated. Thanks.

I'd suggest using File... Get External Data... Link to connect to the multiple
spreadsheets; then for each one run two Append queries to append the data to
the appropriate table. Without knowing the structure of the tables it's hard
to be precise, but I'd guess that there will be one "Unique Values" query to
populate the "one" side table of the relationship, followed by another query
to populate the "many".

John W. Vinson [MVP]