Hi LeeChen,
Access can't handle more than 255 fields in a table. I believe, however,
that you can create views in SQL server each of which contains a subset
of the fields in the table (including its primary key), and then link or
import these to Access tables.
Also, almost always it's possible to normalise a single "wide" table
like this into several "narrow" related tables.
I tried to link/import table from SQL server database. I
can only see up to 256 fields, but the table in SQL
contains more than 256 fields. How can I see all the
fields ?
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.