sql server 2012

  1. N

    Executing or Linking Complex SQL Server code from Excel and show results in Excel linked table

    I have the following query that I need to link to an Excel table in an Excel template that parses this data and then creates charts, etc. using VBA coding. Does anyone have any guidance on how to link this query to the Excel table since it is so complex? I am new to SQL and have never really...
  2. A

    Access front-end with SQL Server OLEDB

    I am creating an Access application that we need to use with SQL Server. I have a some questions that I have not been able to get answers for yet after doing quite a bit of research. I am planning on using a OLEDB connection, However I am a little confused about how to set this up. I have an...
  3. A

    SQL Server table data count in Excel?

    Hello All, I am new to SQL server and VBA, would like to import the table rows count to my excel spread sheet. I have 2000 tables in MS SQL Server. My objective is to get the table name from column A of spreadsheet, execute count(*) query for table and return the value to next column in...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top