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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Connecting to SQL Server thru Access?
thanx geoff but if u dont mind i need a little more help than that. i dont know what ODBC is?!- dmann21
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Connecting to SQL Server thru Access?
Hey. Can anyone help me connect thru VBA to SQL Server. Im using Access and I'm new to VBA. I know theres something like: CurrentDB.OpenConnection and something with ADODB and RecordSets but I don't know anything about it. I'm trying to update the SQL DB and I was using DoCmd.RunSQL but I have...- dmann21
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
how to access excel from VBA? HELP
I need to open an Excel spreadsheet in VBA and then access particular cells to update fields in an Access database. Anyone know how to do this in VBA?- dmann21
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
