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 |
|
Trent
Starting Member
39 Posts |
 Posted - 2004-08-18 : 10:46:22
|
| Is there a way to send data to Access in some way from SQL DB. I just want it to be done programmatically, not by clicking through stuff and selecting data then sending it. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-18 : 11:42:49
|
| There's all kinds of ways to do this from Access. You can use VBA to do a lot of it. What do you have in mind?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
Trent
Starting Member
39 Posts |
Posted - 2004-08-18 : 14:26:26
|
| Thank you for your response, but it was just decided that this won't be happening. |
|
|
|
william_lee78
Yak Posting Veteran
53 Posts |
Posted - 2004-09-07 : 00:41:25
|
Hi, Can you teach me the way to do it using VBA? This is what I'm suppose to do now. I need to transfer my data from SQL 2000 to Access using programatic way. Can you help to teach me? Thanksquote:
Originally posted by derrickleggett
There's all kinds of ways to do this from Access. You can use VBA to do a lot of it. What do you have in mind?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA.
|
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-07 : 00:43:52
|
| You need to buy an Access VBA book. You can find them at www.amazon.comMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Transfer data from SQL Server 2000 to Access