MyODBC 3.51 Unknow table 'xxx_0' in field list

[Ainigma]

When I try to retrieve data using the query wizard in Excel 2002 I get the following
error: "Unknow table 'xxxx_0' in field list" where xxx represents the table name.
Curiously when I follow the exact same procedure for another table in the same database
the problem does not occur.
 
The two tables use the same column types. I tried renaming the table that can't be
accessed but to no avail. I have a workaround where I simply enter the query in a VBA
macro but I really want my collegues to be able to use the query wizard. Is this a know
bug and, if so, are there any workarounds for it?
 
Any help would be greatly appreciated.


		
---------------------------------
Do you Yahoo!?
vote.yahoo.com - Register online to vote today!