sql 2005

  1. S

    INSERT INTO tablename using sql [dynamic table?]

    Hello all! Im trying to insert my record set (using SQL 2005 server [server 2008r2 upgrade coming soon] and office 2013) into a named table "test". (Activeworksheet - for testing purposes.) The purpose is so I can manipulate the data (add columns- remove columns -write formulas in between the...
  2. megnin

    How to call a Stored Procedure with parameters

    Hi, I've tried adapting some VBA code from other posts and I'm not having any luck with this. I could really use some help. I have a Stored Procedure in my SQL 2005 database called: sp_Count_All_YN_Answers_WTP It contains these parameters: @OneStop varchar(50) = '%', @CaseManagerLName...
    • megnin
    • Thread
    • data parameters sql 2005 stored procedures vba
    • Replies: 0
    • Forum: Excel Questions
  3. L

    Update on a Linked Table Failed

    I have a table in Access 2003 that is linked to a sql 2005 server. So far as I know I ahve all the essential parts for this table/form to update to the server correctly. I have a primary key, as well as a timestamp field in the table. Here is the situation i'm attempting and horribly...

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