sql server

I am building a Access Web app in office 365 (something I have never done before). I think by default the tables created in the app are stored in sql server azure. Can I specify or define the names of the sql server azure and link to our on-site sql server? I am trying to sync the data tables...

Hi All, My spreadsheet is a front-end for users to execute queries/store procs against SQL server databases and output the rowset(s) to worksheets, this is all working well. It's the error handling I want to improve, currently my error handling consists of the usual "On error" and displays the...

Hi All, Happy New Year to all of you.. I am an Excel Power user, Excel trainer, BI enthusiast slowly getting into teaching Business Intelligence using Microsoft Excel's PowerPivot. A few years back I was bitten by a bug called Power-BI. I am not a person too good at programming languages. But...

Hi there, I am connecting Excel 2013 to SQL Server 2012, trying to adding a sheet of data to a corresponding table in SQL Server. The code looks like this Dim MoviesConn As ADODB.connection Dim MoviesData As ADODB.Recordset Dim r As Range Set MoviesConn = New ADODB.connection Set...

I have a VBA function called GetBalance(parm1,parm2,parm3,parm4,parm5) that is used to connect to a SQL Server database, execute a query, and return a dollar amount, based on the parameters (type of account, fiscal year and period, balance type, etc.) The function allows users to build very...

Hey all, we have a whole bunch of sql server instances that have the same database and table, id like to be able to update my excel spreadsheet which connects to it via a macro instead of manually going in and changing the server each time. its windows auth all the way, if that helps simply...

I have a general question. Suppose you link SQL Server tables in an MS Access Database. If you write a query from another application (like Excel) to the MS Access database, how much slower would that query be vs. the same query directly to the table(s) on the SQL Server?

Hi, I have created a macro which creates a SQL Server connection and returns data as requested - this works fine, however, my macro involves running the same code a number of times - also works fine, just with different connections - still all working! However, because I am making a number of...

I created a SQL query that gathers information for users to determine which items in our system need to be inactivated. The user receives an Excel workbook that has a table with a data connection to the SQL Server database that pulls in the information they need (via stored proc). I want to...

Hi All, I am able to select data out of my SQL server database into a ListOjbect via VBA. My problem is I cannot make the ListOjbect Refresh. Meaning I would like to be able to select the list object in Excel and right click and choose refresh (currently grayed out) or refresh it via VBA...

I have an assistant who would like to learn more about Sql Server. Does anyone have a favorite author or book?

Can anyone tell me more about this and where to find documentation. Cell A2 has 1, cell B2 has 1028 The Cell H2 has the following text. UPDATE [MyApps].[dbo].[tblTheData] SET [Phrase] = '收款' WHERE CustomerID = 1 and CID = 1028 and CompanyID = 91 This format is repeated for every row - This...

I created an Excel file for mapping columns from other Excel files to a SQL Server table. It works great except for the Chinese files. I set the columns in SQL Server to nvarchar datatype and the Insert text looks great, but when executing, the chinese chars turn into "????" Any suggestions?

I am confused on how to set up my credentials in order to connect and extract data from MS SQL Server using Excel VBA. I know this is possible with an ADO connection, I am not sure of how to setup my code to access my sql database. Can someone please send me a simple code to access my SQL...

Hello all, I'm having an issue with a data connection in Excel 2007. I've not been able to find a solution anywhere online so I'd be tres grateful if anyone could shed some light on this. SQL Server is involved but I believe the problem is with Excel so apologies if people think I'm posting...

We're exploring the idea of linking our access database to a sql server database. When we go down this route, the application gives us 2 options. Our thought is that option #2- Linking to a SQL Server Db by Creating a Linked table is the way to go. However, the system goes on to say that...