Importing a database

[Adam Clark]

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

 

[Scott]

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.

 

[Paul Clement]

¤ 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.

Depends upon what you mean by "import". ADO.NET does not have any native .NET Access or Jet database
engine support so you will be limited to the SQL language that is supported by Jet and OLEDB.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)