Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Panch20
Starting Member
2 Posts |
 Posted - 2010-05-10 : 08:37:28
|
| Hi all,I have a need to translate data from an Access 2.0 16-bit database into a SQL 2005 32-bit database. It needs to be written in VB, in an on-the-fly application. I cannot use DTS and I had a few questions. I've seen problems where the data isn't being ripped out of Access fast enough going into SQL in .NET 2008 using ADO. Should I be using VB6 ADO/VB6 DAO or is DAO in .NET 2008 a better solution (knowing DAO is usually Access only/JET engine) ?Anyone have any suggestions?Thanks! |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-05-10 : 10:43:09
|
| Can't you use the data import wizard in SSMS, or an OPENROWSET Command?------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
 |
|
|
Panch20
Starting Member
2 Posts |
Posted - 2010-05-10 : 13:13:41
|
quote:
Can't you use the data import wizard in SSMS, or an OPENROWSET Command?
No, this is an end-user type tool to be used by multiple people 'out in the field'. #1 They don't have that level of knowledge.#2 They won't access to those tools anyways.It needs to be embedded into a stand alone application. |
|
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-05-10 : 16:44:29
|
| You can build a stand alone application that connects to the SQL DB, and executes a T-SQL statement that uses an OPENROWSET command to read the data from that Access DB and insert it into SQL DB. Any DML T-SQL that you can execute in a SSMS window (with the exception of GO) can be executed from a .net application using a SQLCommand object. Or, you can write a stored proc in the SQL database that uses OPENROWSET to import the data, and then call the sp from you application.------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
|
|
|
|
|
|
Access 2.0 (16-bit) to SQL 2005 (32-bit)