JaedenRuiner
Well-known member
- Joined
- Aug 13, 2007
- Messages
- 340
- Programming Experience
- 10+
Besides the syntax of the call, is there a distinct difference between the two?
Like, basically an Excel Workbook can have multiple sheets, and thus the calling convention for the two commands are:
is there any fundamental difference between these two calls, or is there something about the DATASOURCE call that allows for greater versatility, for example the ability to create a full database with a table for each sheet, etc.
Thanks
Like, basically an Excel Workbook can have multiple sheets, and thus the calling convention for the two commands are:
VB.NET:
OPENDATASOURCE(<string>)...[SheetName$]
...
OPENROWSET(<string>, [SheetName$])is there any fundamental difference between these two calls, or is there something about the DATASOURCE call that allows for greater versatility, for example the ability to create a full database with a table for each sheet, etc.
Thanks
