copy a linked access table to another table 
Author Message
 copy a linked access table to another table

can i copy a linked access table to another table?
and if, how?
thanks

wiemer



Tue, 24 Dec 2002 03:00:00 GMT  
 copy a linked access table to another table

Hi,
You can copy a table with a Select statment:
SELECT * INTO <newTable> FROM <AccessTable>

but you must specify the Catalog and the Shema of the Access Table.

Gerald



Quote:
> can i copy a linked access table to another table?
> and if, how?
> thanks

> wiemer



Tue, 24 Dec 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Linking Access Tables in Different *.mdb Files, Populating an Access Table From Several Others

2. Linking Access Tables in Different *.mdb Files, Populating an Access Table From Several Others

3. Copying the structure of one Access table to a new Access table

4. copy dbase table to access table

5. Copy Dbase table to Access Table

6. MS Access DB - Copy Table A from Database A to Table A Database B

7. Changing the linked table path without the linked table manager

8. How to copy query results to linked table

9. HELP!!..accessing access 2000 with linked SQL Server tables

10. Accessing Linked Oracle Tables in Access Using ODBC in VB

11. Linked Table VS Import Table

12. Make adp table behave like linked mdb table.

 

 
Powered by phpBB® Forum Software