sql server

  1. A

    SQL data connection in Excel - update SQL tables using table in Excel

    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...
  2. S

    Create a Refreshable Listobject via VBA

    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...
  3. Err

    Sql Server Book Recommendation

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

    Cell with UPDATE then SQL Server table/field

    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...
  5. S

    Chinese Characters on VBA Insert to SQL Server

    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?
  6. L

    Connect to MS SQL server through Excel VBA

    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...
  7. L

    Pivot Table: Problem with data connection parameter

    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...
  8. B

    Access Database- Linking to SQL Server Data Source

    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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...