Hi,
I have data as:
<tbody>
</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 connection string & into command line put: "select * from..."
Then into TAB DATA, from Existing Connection menu, connect to the data, and put range/table/pivot_table, where data should be save.
I have data as:
id | name | value |
1 | A1 | 1 |
2 | A2 | 22 |
3 | A3 | 33 |
... | .... | ... |
<tbody>
</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 connection string & into command line put: "select * from..."
Then into TAB DATA, from Existing Connection menu, connect to the data, and put range/table/pivot_table, where data should be save.