I am trying to update a record at SQL Server by using parameters.
The VBA-code does not initiate an error, but the files at SQL Server Table are not updatet with worksheet data.
Can anybody see what I am doing wrong?
Description = Range("E42").Value
Mitigation = Range("E51").Value...
Hi all,
I am a frequent Excel user and want to learn about Power Pivot, as I will have to handle very large datasets.
So I began to read tutorials and saw that SQL is very often a source of data. I installed SQL server 2012 on my laptop and wanted to begin working with...
Goal:
Have a measurement for each PK_test row based on sum of all its quantity from productNumber.
PK_test qty productNumber
-----------------------------------------------
1 5 asdf
2 4 asdf
3...
If you have a fact table that you have uloaded från SQL server to VS2010 SSAS tabular with this table and its data:
Table A
PK_test qty productNumber
-----------------------------------------------
1 5 asdf
2 4 asdf
3...
The below code brings me data from sqlserver, however when im loading back I can only make changes to the first 3 rows on the spreadsheet. When I edit the 4th row I get he error "You can only edit items inside the table".
Anybody knows a solution for this? :eeek:
' General variables we'll...
I want to use the Connection functionality in Excel 2010 to connect to a SQLSERVER 2008 database and populate column X based upon using a value in Excel column A as the primary key (loop thru the column), but unable to find out how.
I have tried (typing in the command text window)
select...