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