SQL field limit

I

imAGine

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
 
J

John Vinson

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.
 
Top