How to import Excel (Xls) File into a SQL Server 2005 table [Archive]

Click to See Complete Forum and Search --> : How to import Excel (Xls) File into a SQL Server 2005 table

rskshiva

07-23-2007, 02:53 AM

Hi,

I need to import the data from an excel file into SQL Server 2005 table.

Only selected column values need to be inserted into required columns of the table.

I need a sql query to achive this requirement.

Thanks in advance.

Best Regards,
Siva