-
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.
sqlserver
-
A
SQL Server Parameter transfer
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...- AadKabel
- Thread
- parameters prm set sqlserver vba
- Replies: 2
- Forum: Excel Questions
-
E
Problem connecting SQL to PowerPivot
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... -
L
Measurement in the Table
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... -
L
SP and Views in Tabular
Is it possible to create some stored procedure and Views with DAX code in SQL server 2012 SSAS tabular? -
L
Customized Table inside of VS project
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... -
H
Inserting data from sqlserver to Excel and vice versa automatically ?
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...- hayath786
- Thread
- excel sqlserver
- Replies: 3
- Forum: Excel Questions
-
K
Want to use Excel2010 cell as primary key parameter for SQLSERVER 2008 query
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...- KWMKWM
- Thread
- cell connection excel parameter sqlserver
- Replies: 6
- Forum: Excel Questions
This Week's Hot Topics
-
separating multiple Proper names (uppercase letters) from a list
- Started by Keebler
- Replies: 35
I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into... -
'for' Loop
- Started by RAJESH1960
- Replies: 29
Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to... -
Open specific pdf in folder with vba
- Started by ipbr21054
- Replies: 38
Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it... -
What is wrong with this For Loop code?
- Started by thardin
- Replies: 20
I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a... -
Data to match
- Started by dinkss
- Replies: 20
Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I... -
Shifting Columns
- Started by Andresleo47
- Replies: 19
Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...
