openrowset

10 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
I have an Excel file with a table and additional text (comments) on the same sheet. I want to extract ONLY the table. How can I do this in SQL?
user_79471370
•
1
0
15
openrowset excel sql
OPENROWSET with Excel file returns DBSCHEMA_TABLES_INFO error
user_11271140
•
1
1
97
openrowset oledb excel sql-server
Not all rows are imported using OPENROWSET in SQL Server
user_162221310
•
2
1
388
openrowset import sql-server-2016 sql-server sql
Not all rows are imported from Excel file using OPENROWSET in SQL Server
user_31870330
•
4
1
959
aceoledb openrowset sql-server
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered
user_99975700
•
2
0
5432
aceoledb openrowset oledb sql-server
SSIS/Azure Data Factory or OPENROWSET/BULK INSERT in Azure SQL DB
user_138104580
•
2
0
403
openrowset azure-data-factory bulkinsert bcp
The metadata could not be determined because every code path results in an error; see previous errors for some of these
user_59361680
•
4
1
13982
openrowset sql-server-2014 metadata sql
SQL Server: Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"
user_24412400
•
13
4
40746
openrowset excel sql-server
T-SQL: issue with string concat
user_3254080
•
15
2
18316
openrowset string-concatenation sql-server-2008 tsql
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)"
user_385950
•
18
7
104727
msdasql openrowset sql-server-2005
  • 1
Hot Questions