table to new table

R

Rivers

hi thanks for your time and help

i have an access table which is an automatic update so its data is
constantly changing but the fields stay the same.
i need to be able to transfer the data at the click of a button from the
linked table into an access table without deleting the data already stored in
the main table.

i have tried looking at the transfer spreadsheet but this does not work.

thanks for the help
 
S

Stefan Hoffmann

hi,
i have an access table which is an automatic update so its data is
constantly changing but the fields stay the same.
i need to be able to transfer the data at the click of a button from the
linked table into an access table without deleting the data already stored in
the main table.
Click to expand...
Create an append query. If your field layout of both tables are identcal
you may use this simple SQL:

INSERT INTO [localTable] SELECT * FROM [linkedTable]


mfG
--> stefan <--
 
D

Douglas J. Steele

Stefan Hoffmann said:
hi,
i have an access table which is an automatic update so its data is
constantly changing but the fields stay the same.
i need to be able to transfer the data at the click of a button from the
linked table into an access table without deleting the data already
stored in the main table.
Click to expand...
Create an append query. If your field layout of both tables are identcal
you may use this simple SQL:

INSERT INTO [localTable] SELECT * FROM [linkedTable]
Click to expand...

And if the layouts aren't identical, include the names of the fields in the
appropriate order:

INSERT INTO [localTable] (Field1, Field2, Field3)
SELECT * FROM [linkedTable] (Field3, Field1, Field2)
 
Top