Can you insert a excel defined table into SQL server on an open workbook in one shot using OPENROWSET. The only references I have seen is using the path for the excel sheet, I want the user to be able to insert the whole table while the workbook is open.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Similar threads
- Question
