How to copy a Access Database to a SQL Database using C#
-
Hi any ideas of how to do this? I have data in a MDB, and i want to import the data to a SQL Database I need to upload it in a ASP.Net page coded in C#, copy to the SQL Server and then, delete the file. Any ideas? I tried some code and make it work, but gives me an error when i try to delete the file (it says that the file is being used for other process). So i want to know if there is another way to do this. thanks :laugh:
-
Hi any ideas of how to do this? I have data in a MDB, and i want to import the data to a SQL Database I need to upload it in a ASP.Net page coded in C#, copy to the SQL Server and then, delete the file. Any ideas? I tried some code and make it work, but gives me an error when i try to delete the file (it says that the file is being used for other process). So i want to know if there is another way to do this. thanks :laugh:
Did you close all the connections before trying to delete the database file?
-
Did you close all the connections before trying to delete the database file?
Yes, i closed all the connections before deleting the database. :((