import dat from Excel to sql database 2005

[mani]

i am new to the programing field so kindly help me

how to import data from excel2003 to sql 2005 database i need code also
and the idea from u


so kindly reply me as soon as possible

[mani]

its very urgent so kindly reply me soon

[Xav]

Create a reference to the Excel automation library. Take a look at the members it offers, than extract the data from the relevant objects into your SQL data project. Finally, you can save the data.

My dad's called Mani - cool, huh?

[justto_doit]

Without excel reference, you can just use database connection to connection to the excel just look the excel as a database.
Read the data out
Process what you need
Insert into the SQL server

Or you may just use the SQL server management studio to import the excel if this is only a one time job.

[Xav]

You could export it as a CSV File. The format is:

,,cell,cell,cell,
,,cell,cell,cell,

Every new line is a new row, and the cells are separated by commas.