255 limitation

[K]

I am linked to an Oracle table that unfortunately has 255+ fields. Is there
a way like a pass-through query where I can return fields in a query that are
past the 255 point?

TIA!

Kim

 

[vanderghast]

SELECT the required fields, and only them. You can make two queries, say one
with the PK and 254 first other fields, and the second, still with the PK
and the other fields (or something similar). Alternatively, normalize that
monster, on Jet side, not on Oracle where you probably cannot change the
design. You can normalize such data with a sequence of UNION ALL:


SELECT pk, "field1" AS source, field1 AS value FROM oracleTable
UNION ALL
SELECT pk, "field2" , field2 FROM oracleTable
UNION ALL
...





Vanderghast, Access MVP