[AccessD] Data from a SQL Server Table

Kaup, Chester Chester_Kaup at kindermorgan.com
Wed May 3 08:37:50 CDT 2006


I may have to do something like that because an export from access to a
text file only got the first 474 characters of the memo field. Why that
number I don't know. Certainly not a multiple of 2. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Long, Karen
S. (CDC/NIOSH/NPPTL) (CTR)
Sent: Wednesday, May 03, 2006 8:24 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Data from a SQL Server Table

Too bad you can't use the Rich Text Format box from .net.  Have you
thought about using vb script to write the contents of the memo field to
a .txt file, displaying that document, making changes, and then send it
back to SQL?  I have some code that will do that - I had a problem sort
of like yours. 


Karen S. Long
Programmer Analyst
EG&G Technical Services, Inc.
Pittsburgh, PA
Phone: 412-386-6649
Email: cyx5 at cdc.gov


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

The problem is I need to manipulate the data.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Tuesday, May 02, 2006 5:17 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Data from a SQL Server Table

Then if you can see the whole value in a form, what's the problem?  You
don't let users see the linked table anyhow. 


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 2:31 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Data from a SQL Server Table

If I directly open the table I do not see the whole memo field. If I
open it in a form I see the whole field.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Tuesday, May 02, 2006 2:59 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Data from a SQL Server Table

Are you using a query to view the data?  Are you trying to sort on the
memo field? 


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 11:52 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Data from a SQL Server Table

Access 2003
SQL Server 2000

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

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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



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



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



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

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