XL to Table using sqlserver2000

try this query

SELECT * INTO XLImport5 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\test\xltest.xls', 'SELECT * FROM [Customers$]')
or refer the below link

http://support.microsoft.com/kb/321686

Thanks&Regards
LakshmiNarayana Nalluri.

Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator

INSERT INTO dbo.Test_Sql1234
SELECT Name,eid FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Book12.xls',[Sheet1$])
Go

Where dbo.Test_Sql1234:- is my TableName
Name,eid :-are my columns
C:\Book12.xl :-Is the file name containing in c drive
Sheet1:-is the sheet no, present Excel sheet

Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator

try this also

http://stackoverflow.com/questions/375991/import-excel-spreadsheet-columns-into-sql-server-database

Thanks&Regards
LakshmiNarayana Nalluri.

Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator