Worksheets_To_Table
Extracts names of Worksheets from an Excel Workbook
- Stored Procedure
- SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017
EXEC SQLHTTP.net.Worksheets_To_Table @WorkbookPath
| Name | Type | Description |
|---|---|---|
| @WorkbookPath | nvarchar(4000) | The path to a Microsoft Excel Workbook |
| Column name | Data type | Description |
|---|---|---|
| Worksheet | nvarchar(MAX) | Name of a Worksheet in the Excel Workbook |
SQL Server 64 Bit Instances: This function requires the “Microsoft Access Database Engine 2010 Redistributable.” Please see the following for more information: https://www.microsoft.com/en-us/download/details.aspx?id=13255
|
1 2 3 4 5 6 7 |
DECLARE @WorkbookPath varchar(MAX) SET @WorkbookPath = 'C:\ThisFolderExists\OLEDBProviders.xlsx' EXEC SQLHTTP.net.Worksheets_To_Table @WorkbookPath |
|
1 2 3 4 5 |
Worksheet ------------- SampleSheet |