export dynamic data

  1. F

    Export data from Excel to MS SQL

    Hi, I have data as: <tbody> id name value 1 A1 1 2 A2 22 3 A3 33 ... .... ... </tbody> How to export the data (Range:A1:C&i) to MS SQL server, to table called "test"? I know how to get/select the data from MS SQL: TAB DATA/Connections/Workbook Connections/Add... then just add...
    • Forestq
    • Thread
    • export data export dynamic data sql sql database sql excel ado
    • Replies: 2
    • Forum: Excel Questions
  2. N

    Looking for a wee bit of help with VBA

    Hi While having a reasonable understaning of excel, when it comes to VBA, I am a complete novice. I am attempting to use a macro to do what I hoped was going to be a simple task, but have run up against a stumbling block which I am sure one the of the guru's here will be able to solve in less...

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
Back
Top