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 |
|
nizam
Starting Member
15 Posts |
 Posted - 2005-08-01 : 23:03:17
|
| hi. how can i convert mssql data to access using visual basic 6.0 script |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-02 : 00:53:17
|
| MSSQL has a tool called DTS which can import and export from & to Access. You could "launch" a DTS job from VB (or it could be scheduled etc.)Dunno if that would do the trick?Kristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-02 : 00:56:19
|
| If you want to export the data from single SQL Server table to Access you can use OpenRowsetSee BOL for the syntaxMadhivananFailing to plan is Planning to fail |
|
|
|
nizam
Starting Member
15 Posts |
Posted - 2005-08-07 : 22:38:47
|
| thanks a lots |
|
|
|
|
|
|
convert mssql data