Transferring data from Excel Sheet to SQL Server 2000 database

[Dextter]

Hi all, I'm working on a university results project and i need to transfer data from an already existing Excel spreadsheet to my sql server database, so that i can readily perform queries on legacy data. I also intend to use the DAAB of the Microsoft Enterprise Library (January 2006)to implement it. Can anyone help me on how to go about this? Obinna from Nigeria.

//obinnaaj Eof

[Bijesh]

If you are trying to do this by C# code, then I suggest looking at the Microsoft.Office.Interop.Excel namespace