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 |
|
|
|
|
|