-
copying tables???
Hi,
I am making a 'archive' database which keeps track of older reservations. Each year I need all the reservations for that year in their own table, for example tblReservations2002.
I had started to try to create tables dynamically and add fields dynamically and then fill the table with data, but then i thought there must be a simpler way to do this.
Is there any way thru vb to copy (export) an entire table from one database to another, keeping all data intact?????
Thanx a bunch
-
via a reference to the access application itself you can do this