Importing Access MDB into SQL Server 2005 with Stored procedure
Posted on 2007-11-30
Pretty straightforward, I am looking for the code to import a MS Access MDB database into SQL Server 2005 with a stored procedure.
I have seen examples of this with excel or csv files, but I have not seen and cannot figure out how to do it with a mdb and in a stored procedure. I need to do the import 'hands off', and the data will change completely three times a day, that is why it needs to be a stored procedure.
The SQL server already has a table with matching specifications so there is no need to create or drop tabels. I just want to import the data into an empty but existing table.
(I'll be deleting the data in the SQL Table beforehand, I already figured that part out)