VBA to copy a table from SQL database

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

VBA to copy a table from SQL database

Logged in as: Guest

arrSession:exec spGetSession 2,7,53459

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [General Forum] >> Other Programming/Scripting Languages >> VBA to copy a table from SQL database
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

VBA to copy a table from SQL database - 11/12/2007 2:02:41 PM

avkuvalekar

Posts: 13
Score: 0
Joined: 11/8/2007
Status: offline

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! :)

Post #: 1

RE: VBA to copy a table from SQL database - 11/12/2007 2:09:25 PM

TNO

Posts: 1064
Score: 10
Joined: 12/18/2004
From: thenewobjective.com
Status: offline

http://www.w3schools.com/ado/default.asp

_____________________________

To iterate is human, to recurse divine. -- L. Peter Deutsch

(in reply to avkuvalekar)

Post #: 2

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.

All Forums >> [General Forum] >> Other Programming/Scripting Languages >> VBA to copy a table from SQL database

Page: [1]

Jump to:

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts