Forum Discussion
Query from Excel in Synapse Serverless
I'm trying to use the following code to read from an Excel file using Synapse Serverless. Is this even possible? SELECT *
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 Xml;HDR=YES;Databas...
Synapse Serverless can’t read Excel files directly. Convert the Excel file to CSV, upload it to Blob Storage, then query it using OPENROWSET with FORMAT = 'CSV'.