Forum Discussion
vxramad
13 years agoContributor
Thanks. Hoped that i can directly update the variable.
Anyways, i have tried with the DB variable wizard. I have one small issue and i am not able to figure it out
I have provided the correct provider, data source and Extended properties (For Excel 2007)
and i am able to see all the three sheets of the Excel sheet.
But after selecting the excel object i am getting an error saying "unable to retrieve data from the specified database object. The database engine reports: Syntax error in FROM clause"
I am not able to figure out the issue as i am selecting the sheet from the drop down and i am not providing any additional information
I have attached the screen shots. Please provide a solution.
Anyways, i have tried with the DB variable wizard. I have one small issue and i am not able to figure it out
I have provided the correct provider, data source and Extended properties (For Excel 2007)
and i am able to see all the three sheets of the Excel sheet.
But after selecting the excel object i am getting an error saying "unable to retrieve data from the specified database object. The database engine reports: Syntax error in FROM clause"
I am not able to figure out the issue as i am selecting the sheet from the drop down and i am not providing any additional information
I have attached the screen shots. Please provide a solution.