Today I use
SELECT * FROM [Plan1$]
To select Excel spreadsheet data, I would like to know how to select the record row as well.
Select the ROW_NUMBER of an excel table
0
asked by anonymous 02.05.2018 / 14:36
1 answer
0
You can use where to filter the desired records:
SELECT *
FROM [Plan1$]
WHERE [Field_name] = "myFilter"
03.05.2018 / 00:45