Linking two spreadsheets

[Pete]

Hi,

I have two spreadsheets - one is 45,000 rows (relates to 2006 sales) and the
other is c25,000 rows (relates to 2007 sales YTD). I am trying to combine
the two spreadsheets into one Access table. The 2006 data does not change
but the 2007 data gets bigger daily.

So far, I have been succesful in "importing" the data into one table but
this isn't very fliexible - I would have to "re-import" 2007 each time I use
the database.

Is there any method I can use to have one table....with 2006 imported but
2007 linked ?

Thanks in advance
Pete

 

[Douglas J. Steele]

What's wrong with linking both?

 

[John W. Vinson]

Is there any method I can use to have one table....with 2006 imported but
2007 linked ?

Not one table, but you can get one recordset. Import the 2006 table, and link
to the 2007, and create a UNION ALL query to string them together (don't use
just UNION, since you won't have any legitimate duplicates to exclude).

SELECT this, that, theother FROM [Local2006Data]
UNION ALL
SELECT this, that, theother FROM [linked2007data];



You may have problems with poor performance on this, but it'll at least give
you the data without repeated (and database-bloating) imports.

John W. Vinson [MVP]

 

[Cool Man Dude]

I don't know