Hi Everybody,

I am writing an application in VB with an Access database, in which information is grouped together by project numbers. When a project is completed I need a way of archiving all the information for that project into a separate database. The way that I was thinking about doing it was having a template database already set up, and then when I need to archive the data I would do a SELECT and then an INSERT statement, and then copy the template database to a different name. My problem is that I’m not sure how to do the INSERT statement from one database to another. If anyone knows how to do this, or a better way it would be greatly appreciated.

Thanks in advance.