SQL field limit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have imported a querry from Microsoft Querry that extracts data from a SQL Table. The SQL table has more fields than can be viewed using Access. Is there a way to right a querry that will extract information from the tables fields that cannot be seen? I tried using the SQL function of the Microsoft Access Querry with no success
 
I have imported a querry from Microsoft Querry that extracts data from a SQL Table. The SQL table has more fields than can be viewed using Access. Is there a way to right a querry that will extract information from the tables fields that cannot be seen? I tried using the SQL function of the Microsoft Access Querry with no success.
Click to expand...

If you're working with a "data warehouse" table with more than 255
fields, the only option I can think of is to create two or more SQL
Views displaying subsets of the fields.
 
Back
Top