Trying to convert an old access system to OpenInsight as a 'proof of concept' which should bring some bigger system conversion (that's what they always say :) but ..

It is an OLD access .. v2.n I have odbc connecting for data but the tablenames contain spaces and other non-standard SQL names. I believe that the standard is to surround the names with square brakets .. but at this point it does not appear to work.

Any quick ideas on accessing these tables? Don't have access on site so can't simply change table names

thanks

As I recall, square bracket notation is for DAO running inside of Access. If you are using ODBC, I think you surround names with double quotes, e.g.

select * from "my table"

can test in the query window.

If you have Excel you can build a query there (tools/database/Get_ExternalData/Odbc), look at the SQL it generates

Bob

View this thread on the Works forum...