- Execution of an SQL statement in OLEDB to get the data in a Collection.
SELECT * FROM [Sheet1$]
I must obtain the data from an excel file and I am using the OLEDB object, which brings me all the rows of the sheet.
But in my case, I need to get the data starting from row A9, since I won't need the rest. Is there a way that in the query I can modify which row I want to get the collection from or not?
Kind of like a range or something like that.
------------------------------
Fatima Alcaraz
------------------------------