Facing Error while reading Excel file through ODBC connector

atul9806 · Post by **atul9806** » Fri Jun 01, 2012 7:30 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Jun 01, 2012 4:30 pm

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.

atul9806 · Post by **atul9806** » Fri Jun 01, 2012 7:08 pm

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.

chulett · Post by **chulett** » Fri Jun 01, 2012 8:04 pm

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.

dave239 · Post by **dave239** » Wed Oct 10, 2012 1:12 pm

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