Cannot select range for sheet names with special characters (OLE DB SQL Server)

ykejflvf 于 2023-08-02 发布在 SQL Server

关注(0)|答案(1)|浏览(130)

I'm trying to select data from Excel using OLE DB, but the other sheet names in the provided file has special characters.

For example: Sample_Sheet - #1

How do I go about this?

I tried

SELECT * 
FROM [Sample_Sheet - #1$]

and it displays the data.

However, when I specify a range in the query:

SELECT * 
FROM [Sample_Sheet - #1$D7:G22]

OLE DB throws an error

Microsoft Access database engine could not find the object

Any insights will be appreciated. Thank you!

sql-server

来源：https://stackoverflow.com/questions/76759209/cannot-select-range-for-sheet-names-with-special-characters-ole-db-sql-server

1条答案

按热度按时间

bhmjp9jg1#

Your SELECT statement looks very dubious.

Here is how it is usually done in SSMS:

SELECT *
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
   'Excel 12.0 Xml;
    Database=e:\Temp\SheetWithTable.xlsx',
    'SELECT * FROM [SheetWithTable$A1:B3]');

赞(0）回复(0）举报 2023-08-02

我来回答

Cannot select range for sheet names with special characters (OLE DB SQL Server)

1条答案

相关问题

热门标签

最新问答