Create table using data from linked table

[Tommy]

I have two linked tables that contain daily data from two CSV files.
These tables are called 'PHD' and 'XANS'. Each table has the same
column headings, so the data is common between the two. I would like
two merge the data from these tables into a single table where the
data with the same headings appear together in the same field e.g. I
have a field called 'Tagname' in both linked tables. In the new table,
I would like all tags in the 'Tagname' fields of both PHD and XANS to
appear in a single field.

Ideally I would also like this table to automatically update as I
update the CSV files daily.

How do I go about doing this?

Regards,

Tom

 

[Stefan Hoffmann]

hi Tommy,

I would like
two merge the data from these tables into a single table where the
data with the same headings appear together in the same field e.g. I
have a field called 'Tagname' in both linked tables.

Use a Union query:

SELECT fieldList FROM PHD
UNION ALL
SELECT fieldList FROM XANS

The fields must be of the same type and number. In the first Select you
can rename the result fields using fieldA AS A, .., fieldZ AS Z

In the new table, I would like all tags in the 'Tagname' fields of both PHD and XANS to appear in a single field.

This seems to be nonsense from a theoretically point of view, it is
called Denormalization. See

http://en.wikipedia.org/wiki/Database_normalization

Ideally I would also like this table to automatically update as I
update the CSV files daily.

Just use the Union query above for a append query.


mfG
--> stefan <--