assuming you mean a copy or merge, on a table by table basis.....
Spare yourself the pain of doing it the hard way, and use Sql Server DTS
utility
If you dont have a SQL Server, buy a copy of SQL 7 ( which also has DTS ) on
ebay and load that up. a copy SQL 7 would be chump change compared to the
time and effort you'll put into coding a utility from scratch.
"Adam Clark" <ad********@lhpsoftware.com> wrote in message
news:eh**************@TK2MSFTNGP12.phx.gbl...
Is there a way to import a database into another database using code with
ADO.NET (assume a microsoft access database in both instances)?
I know you could do it with VB6 and DAO.
Thanks
Adam