import data from an Excel sheet to the database

[kunwargadhok]

I want to import data from an Excel sheet to the database , for which I need to read the Excel file and insert the data into the database.
How do I do it?
Is there any other way of doing it?

[JoshT]

There's two ways I know of:

1. Set a reference to Excel's Object library, then you can automate it - Dim x as Excel.Application, etc.

2. There's an driver or provider you can use with ADO like the spreadsheet was a database.

[kunwargadhok]

Hi Josh And Gaffer!
Thanks a lot for your prompt reply.
I had done it the way you have told When i saw your reply.
Iam working in Tata Consultancy Services(INDIA).
I have worked on Java , XML and right now Iam placed in a project with ASP , VB and Oracle8.i
How about you?

Thanks&Regards,
Kunwar Gadhok
[email protected]