I am trying to open an Excel 5.0 using VisData in VB5. I go to VisData, open the file using "Excel", and when I right click on the table, I get the sheet up on screen. However, when I try to create a SELECT query, I get problems. In the Database window, it shows the table as being called
"Sheet1$". So I put in an SQL query
SELECT * FROM Sheet1$
and I get a syntax error in FROM clause, error no. 3131. So I write
SELECT * FROM Sheet1
and I get asked if it is a Pass Through query. I say "No" and then get
Cannot find object "Sheet1". error 3011.
I cannot work out what the problem is. I have even tried using the query builder, with no success. I should also say that I have been able to access text files (using the correct commands of course) with no trouble whatsoever. I am totally stumped. please help.