Copying records from jet database to a new jet database
Matt,
Quote:
>I would like to copy records from one jet database to another. I'm trying
>to do a year end archive....Is that possible?
Sure. You can do an APPEND query that uses the IN argument to specify
the target database. Or you could ATTACH to the table in the other
database and treat that table as if it were local.
Quote:
>If so, could you show my some sample code?
There's not much "code" here. It's just a query. If you have a copy of
Access the easiest way to write the query is visually through the
query designer.
-- Jim Ferguson, FMS
http://www.*-*-*.com/
