avkuvalekar
-
Total Posts
:
13
- Scores: 0
-
Reward points
:
0
- Joined: 11/8/2007
-
Status: offline
|
VBA to copy a table from SQL database
Monday, November 12, 2007 3:02 PM
( permalink)
Hi Guys, I need to copy some sql table onto my spreadsheet. I have the code that establishes connection with the sql database. I also have got the code that queries the required table. Now I need to copy it. The thing is although I have the code, I am not very clear as to what ADODB does, the methods within and how to use and copy / paste the data. Can someone of you please give an example or a link to a good tutorai where I could possibly learn this? Thanks a lot! :)
|
|
|
|
TNO
-
Total Posts
:
2094
- Scores: 36
-
Reward points
:
0
- Joined: 12/18/2004
- Location: Earth
-
Status: offline
|
RE: VBA to copy a table from SQL database
Monday, November 12, 2007 3:09 PM
( permalink)
To iterate is human, to recurse divine. -- L. Peter Deutsch
|
|
|
|