Hello,
In the serverless sqlpool I have created views to read .csv files using openrowset, etc.
How is it possible to read a .xlsx file?
I tried something like this but it is not correct
SELECT *
FROM OPENROWSET(
BULK 'Input/file.xlsx',
DATA_SOURCE = 'xyz',
FORMAT = 'Excel',
HEADER_ROW = TRUE
)
AS [r]
Thank you
or upvote
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is