Higa, you are right. But in my case, the excel sheet will have only two columns and I know for sure it doesnt cause any problems.
Now I have a new problem. Its about sheet names in the excel. I...

i am changing the excel column to varchar before i actually write to the sql table.
i used this earlier:

INSERT INTO table(c1,c2)
SELECT Code1,Desc
FROM OPENDATASOURCE...

hmm..will let you know my findings or what ever i do. thanks man. repped.

All is done and working but when i import the data from the excel to sql table, i see a change in the data.
the excel sheet has a column with numbers stored as text. they have a 0 as the first...

thanks a lot.
Started on the same path before posting that question. Acheieved the result in a similar way.

Is there any way we can specify the file name and location in Datasource as a variable?

Like can we replace the following with a variable?

'Data Source="D:\spreadsheets\test.xls";Extended...