MSAccess DB import to SQL server using C#
-
Hello Friends, I need to import a MSAccess Database to SQL server 2005 using C# code. My question will be is it possible to do so?--I googled and am yet to find a satisfactory answer.So i thought i will post the question. Also is it possible to import a txt file to MSAccess? If yes can you guys give me any links please. Thanking You all
-
Hello Friends, I need to import a MSAccess Database to SQL server 2005 using C# code. My question will be is it possible to do so?--I googled and am yet to find a satisfactory answer.So i thought i will post the question. Also is it possible to import a txt file to MSAccess? If yes can you guys give me any links please. Thanking You all
TXT to Acess: google search for "Access import txt" Access to SQL Server: google search for "sql server database import wizard" If you only need to import the access database once, there's no reason to write a program to do it. If you need to import the database on a regular basis, then all you need to do is run the import wizard once, then when the wizard prompts you to "Save SSIS" package, save it as a local file. Then you can simply setup a scheduled job to run dtexec and import the database. If you need more control than that look at the SQL Data Compare tool from RedGate software www.red-gate.com[^].
Mark's blog: developMENTALmadness.blogspot.com Funniest variable name: lLongDong - spotted in legacy code, was used to determine how long a beep should be. - Dave Bacher
-
TXT to Acess: google search for "Access import txt" Access to SQL Server: google search for "sql server database import wizard" If you only need to import the access database once, there's no reason to write a program to do it. If you need to import the database on a regular basis, then all you need to do is run the import wizard once, then when the wizard prompts you to "Save SSIS" package, save it as a local file. Then you can simply setup a scheduled job to run dtexec and import the database. If you need more control than that look at the SQL Data Compare tool from RedGate software www.red-gate.com[^].
Mark's blog: developMENTALmadness.blogspot.com Funniest variable name: lLongDong - spotted in legacy code, was used to determine how long a beep should be. - Dave Bacher