[AccessD] Data from a SQL Server Table

Kaup, Chester Chester_Kaup at kindermorgan.com
Tue May 2 11:10:59 CDT 2006


I am try to view the data from a SQL table that has one field that
Access shows in design mode to be a memo field. Only part of the field
displays. I tried exporting it to a text file and viewing it in Wordpad.
I see more of the field but not all of it There is a distinct cutoff
point (474 characters total on one line). Any suggestions on how to see
all the contents of the field. I tried the LEN function on the field for
one long record and got a count of 240. I know there are more characters
than that. Does LEN not work on memo fields?

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.

 




More information about the AccessD mailing list