Data Import Access to SQL Server
-
Hi, I want to develop a application in VB. That will import data from MS-Access table to SQL server table. We have many ways to do same things • SQL Server Data Transformation Services (DTS) • SQL Server linked servers • SQL Server distributed queries • ActiveX Data Objects (ADO) and the Microsoft OLE DB Provider for SQL server • ADO and the Microsoft OLE DB Provider for Jet 4.0 or if u know some other way. I want to do build the application in more professional way. So i want smart suggetion from any one. Thanks Amit Chowdhury
-
Hi, I want to develop a application in VB. That will import data from MS-Access table to SQL server table. We have many ways to do same things • SQL Server Data Transformation Services (DTS) • SQL Server linked servers • SQL Server distributed queries • ActiveX Data Objects (ADO) and the Microsoft OLE DB Provider for SQL server • ADO and the Microsoft OLE DB Provider for Jet 4.0 or if u know some other way. I want to do build the application in more professional way. So i want smart suggetion from any one. Thanks Amit Chowdhury
How about using the UpSizing Wizard in Access? RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-
How about using the UpSizing Wizard in Access? RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-
First thanks for your reply. I want to make simple interface application in VB for some user thay don't know any thing about UpSizing Wizard in Access or DTS. Amit Chowdhury
If you know the format of the tables, there's nothing magical about it. All you do is read the Access table, do any translation that you need to, and write it to the SQL table. The connection technology you use for either one is up to you. In VB.NET, all this stuff is supplied in the .NET BCL. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome