Access: Retrive Data from a table with more than 255 fields

R

RPG

I am trying to used Access 2003 to access data from a table with more than
255 fields. I need a field in the 310th field. Can the 255 field limit be
"tricked". If not, please suggest a software option
 
J

John Spencer

If the data is in MS SQL Server, you can write a view with an assortment
of fields (less than 256) and use that as the source "Table" for a query.

Obviously the records are not in a table in Access Jet.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
D

Douglas J. Steele

I believe that I've linked to tables in external sources that have more than
255 fields, then written queries that picked specific fields by name.
Obviously the query must have fewer than 256 fields.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to Access all fields in MSSQL 2005 tables with Access 2007? 5
Transfer a string longer than 255 chr from an access form to word 1
When you import a Microsoft access field into Microsoft word, the 2
insert memo feild into a memo field truncates at 255 characters - 4
FIeld with more than 255 char on report 0
Can't pass string >255 characters to Word document with VBA 3
Make Table Query Truncating Memo Field at 255 Characters 2

Top