-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
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
Some videos you may like
This Week's Hot Topics
-
Payment term and Cash flow (formula linked with costs)
- Started by Adfinance
- Replies: 43
Hi everyone, I need to calculate automatically the cash position (cashout) based on payment terms and costs. The payment terms may change, so I... -
Match to a list with wildcards
- Started by The Gent
- Replies: 29
Good day all, I am trying to do something which it my head feels quite simple but I can't get a result. I have four dimensions in a spreadsheet... -
Inserting text above first blank row then above third blank row etc.
- Started by Livin404
- Replies: 24
Greetings, I have a VBA where I'm trying to insert text into blank cells. On worksheet "Deficiencies" I have seven groups of ranges that I... -
code to get students marks from source sheet to destination sheet.
- Started by rzml
- Replies: 22
hi, I am looking for a VBA code that can get student marks using his ID and evaluation type (as headers) from source sheet to destination sheet. I... -
Run VBA on all open tabs
- Started by Dannottheman
- Replies: 22
Hi, I searched but could not find an answer to this. How can I make the 3 VBAs below run on all the open sheets/tabs in my Excel? Right now I... -
Functions to separate a string separated by commas
- Started by jeffdolton
- Replies: 22
Hi, I’ve opened up another thread as my request this time is a little different. With help from experts on this forum, and using some basic excel...