Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pass a variable

Status
Not open for further replies.

suoirotciv

Programmer
Dec 3, 2002
205
PH
I need to loop to lots of excel file so i need to pass the file name. But using SET @FileName = 'C:\MyExcelFile.xls' and pass it on the code below is not working.

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\MyExcelFile.xls;HDR=YES', 'SELECT * FROM [Sheet1$]')

My Code
Code:
SET @FileName = 'C:\MyExcelFile.xls'

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database='+ @FileName + ';HDR=YES', 'SELECT * FROM [Sheet1$]')

========================================
I kept my Job because of TEK-TIPS
Thanks a lot to all who keeps on helping others.
 
I got it, its not possible to pass variable to OPENROWSET so I just use EXEC

But my problem now is that my excel file contains phone number and when the data was transfered to my table the phone number becomes like this "3.9522e+006" where my field is already varchar

========================================
I kept my Job because of TEK-TIPS
Thanks a lot to all who keeps on helping others.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top