DSXchange

Hi All
I know this is a repeating question but I didn't find the answer so asking again

I am facing the issue while writing the SQL statement to fetch the data from the ODBC connection.
I am confused with the table name of that xls sheet. I imported the data with the system tables. while importing the metadata I can see the data of xls in view tab but unable to read file in stage.

When I tried to build a query to read the data, it shows the table name as
"DSUNKNOWN.sheet1$" but after writing the query when I validating it with view data, its not working :'(

Please help

How are you building the query? Can you try using generated SQL, where you enter the table name manually? If you use the SQL Builder, make very sure that you include the step of adding the table name.

Hi Ray
I am not able to see what you written here. It is saying its a premium content.

But As I got, Yes, I build the query with SQL builder given in stage.

atul9806 wrote:I am not able to see what you written here. It is saying its a premium content.

Been that way for a long time here.

memberbenefits/

They don't come any more premium than Ray.

Problem with reading excel file must be corruption I would suggest you following utility for opening files http://www.recoverytoolbox.com/repair_excel.html