Thanks everyone.

I finally got the code which will import excel data to sql server. 🙂

INSERT INTO sqlservertable

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel

8.0;Database=C:\1.xls', 'SELECT * FROM [sheet1$]')

This code is correct but...

Thanks for all replies.

this is not a one time task.

In fact, on the daily basis excel files will get uploaded in a directory (at least 20 files), there is a...

Thanks for reply.

yes, frontend is MS Access which will be connected to MS SQL Server but frontend will be used by users only. Data need to be moved from MS...