How to Access all fields in MSSQL 2005 tables with Access 2007?

  • Thread starter Thread starter Amos Sobel
  • Start date Start date
A

Amos Sobel

I am trying to manipulate SAP B1 MSSQL2005 data with Access 2007. I did find
that SAP B1 is using more than 255 fields on MSSQL2005 tables which are
inaccesible by Access 2007.
Is there a way to bypass this problem and access all MSSQL2005 table fields
from Access 2007?

Your help is very wellcome
Amos
 
....and that being said, what exactly are you trying to do? While working with
over 255 fields isn't outside the realm of possibility, I find it highly
unlikely that you would actually NEED to work all the fields at one time.
 
Dear David

Thank you for coming back.

In the case I am working on, I need to access 20 fields out of 280 fields in
the Mssql Table. Some of the fields are higher than 255 so I can't access
them with the current Access2007.

Amos Sobel
 
Dear David

You did talk me to the very simple solution:

I have to create a MSSQL2005 VIEW which will pass the 20 relevant fields
into Access2007!

Thank You!

Amos Sobel
 
Just explicitly select the fields you're working with as in...

SELECT FirstName, LastName, City FROM myTable
 
Back
Top