in reply to Re: how do i extract data from excel sheet?
in thread how do i extract data from excel sheet?
As far as "database" stuff goes, you may be confusing Excel with Access. To my knowledge, Excel doesn't "export" its worksheets with any database-ish mechanism at all.
Data in Excel is stored in a database-like format although this mechanism is a secondary feature. It is there to allow DB applications to read the data although Excel itself doesn't strictly require it. You can access Excel data for reading and writing using ODBC or ADO.
John.
--