Not all fields show up in Linking, Importing table from SQL server database

  • Thread starter Thread starter LeeChen Hwung
  • Start date Start date
L

LeeChen Hwung

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 ?
 
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 ?
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top