[AccessD] Data from a SQL Server Table

Charlotte Foust cfoust at infostatsystems.com
Tue May 2 11:28:40 CDT 2006


Which versions of Access and SQL Server? 


Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Tuesday, May 02, 2006 9:11 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Data from a SQL Server Table

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.

 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list