title: C# import MS-Access database into SQL Server?
body: <p>I need to import data from a MS Access database into a SQl Server 2000 database once a day. Since I need this to be done every day automated is there a c# routine which would be able to do this?</p>
  
  <p>The tables in the MS Access database will be named as the same tables in the SQL Server and it needs to delete the tables in the SQL Server database and then import the new data/tables from MS Access.</p>