I have a table that is being imported from Sybase that contains > 255 fields.

We only need a small subset of these fields, however, so the desired stored table is something Access can handle (~ 20 columns).

The connection setup is ODBC, and of course, an openrecordset command just gives the first 256 fields. When I do a SELECT on a fields not in the first 255, of course, there is an error.

Is there...