Ling to an SQL Table that exceeds 255 Fields

[Jody Butcher]

I am using an ODBC Link to an SQL Table that has about 400 fields in it. I
need to get to some of the fields in the 300+ range. Anyone know of a way to
do this?

 

[Rick Brandt]

I am using an ODBC Link to an SQL Table that has about 400 fields in
it. I need to get to some of the fields in the 300+ range. Anyone
know of a way to do this?

I beleive you will need to define a view on the server that has the fields you
need or else use a Passthrough query instead of a link.

 

[Brian]

If you have access to the main database to which you want to establish the
ODBC connection, you could create a view (SELECT statement that returns just
the fields and/or records you need) or have the DB developer create the view
for you. Then, you can just set up your ODBC link to the view instead of to
the table itself. The view can be either read-only or have read/write access
to the database.