table to new table

[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

 

[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.

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 <--

 

[Douglas J. Steele]

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.

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]

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)