I'm using ADO at VB&VBA.
I have to import data from excel sheet as recordset format.
I tied to do as the same way to expert Access Data but I failed.
How can I expert excel data and open recordset.
I need to read excel files from VB application. My first question what I should use ADO. When I've tried ADO I can choose only mdb files, if I choose excel file(.xls) I got message that file is in unrecognized file format.
Of course I can create and link access data base with exl file and after that use this access database, but I didn't think that it is good solution.
So how to use ADO to read excel files ?
And How to open recordset?
Please teach me with detail VB code.
Thank you for your time.