Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jag7777777
-
SQL connection from Excel VBA
Thanks for the replies everyone. dhookom - thanks for the time taken to post the code - extremely helpful post. skipvought - can you point me in the direction of some good resource for MS Query - I know nothing about it! :-) I'll have a look at both options and then see which one is best for...- jag7777777
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
SQL connection from Excel VBA
Hi Everyone, Could somebody help me please with the code that I need to gain a connection with a SQL server? Assuming the following: Server Name: Server DB Name: DB Login name: login Password: password Could someone please post what the procedure would look like in VBA so I could run a...- jag7777777
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel VBA SQL connection
Hi Everyone, Could somebody help me please with the code that I need to gain a connection with a SQL server? Assuming the following: Server Name: Server DB Name: DB Login name: login Password: password Could someone please post what the procedure would look like in VBA so I could run a SELECT...- jag7777777
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
