I have connected successfully, using ODBC, to some remote data. In my case its to Btrieve data, but that's not significant for this question.

Most of the tables have "normal" field names and work fine. The tables I now have to access, have field names like the following:

AM>Driver
AM>Order #
AM>Order Date

My error message says that there is no such column. I saw an earlier thread (but can't currently find it) that talked about problems with the # character and had some sort of workaround. I seem to also be having trouble with the > character. I'm also confused as to how to handle imbedded spaces in the field names. I'm trying to do something like
SELECT * FROM TheTable WHERE (AM>Order #) = "12345"

I don't have the option of having the field names changed in the remote data.

Bob