-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
ms sql
-
F
Connecting Vba to MS SQL (return & display value)
Hi I'm doing simple connection to MS SQL and want to get count and display into excel: Sub test() Dim conn As ADODB.Connection Dim rcrds As ADODB.Recordset Dim iRowNo, i As Long Dim id, name, value As String Dim wb As Workbook Dim ws As Worksheet Set wb =...- Forestq
- Thread
- ms sql sql sql excel sql excel ado sql for beginners
- Replies: 6
- Forum: Excel Questions
-
S
SQL Query translated to Access
Hi, I am trying to translate this query to Access: The main challenge I am having is the Count column- it gives and error: Syntax Error(missing Operator) in Expression "Count....." some of it was already translated- but the count is where the issue is. SELECT TblFacility.StrFacilityName ...- saschmeling
- Thread
- access-2013 ms sql query
- Replies: 1
- Forum: Microsoft Access
-
D
PowerPivot and MS SQL Azure
Has anyone tried to use PowerPivot with MS SQL on the Azure cloud? If not, would anyone like to test it with me?- dbailey
- Thread
- azure connector ms sql ms sql azure powerpivot
- Replies: 0
- Forum: Excel Questions
