Re: join tables sequencialy

On Wed, 26 Nov 2008 23:32:01 -0800, Yossi evenzur
<Yossievenzur@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi Duane
here it is: i have 2 tables with the exact field structure and names, 240
fields.
one table starts on 03/08/2008 and ends on 25/10/2008 the second table
starts on 26/08/2008 and end on 22/11/2008. i need treat these tables as one,
meaning, i'd like to have one table that starts on 03/08/2008 and ends on
22/11/2008 with consecutive entries and without multiple identical entries,
e.g. not to have double entries for 01/09/2008. I have 6 pairs of these excel
sheets and i really want to avoid the cut & paste and without SQL IF POSSIBLE.
hope this is more clear :-)

One thing that may not be obvious: there is *nothing* magical about SQL. Don't
confuse the language SQL (short for Structured Query Language) with the
software product SQL/Server! All queries, whether built using the query grid
or not, are SQL; it is *the* language of queries. So you're using SQL any time
you use Access.

Since you're dealing with non-normalized spread*** data, I fear a UNION
query will indeed give problems. However it should be possible to create a
local table in Access with the same 240 fields; you can set a unique Index on
the field or combination of (up to ten) fields which define "a unique entry".
You'll then be able to run Append queries to migrate the data from the
spreadsheets into this table; duplicates will be removed in the process by
this unique index. If there are more than ten fields that define a duplicate
you can remove the duplicates later if need be.
--

John W. Vinson [MVP]
.