ODBC Not Displaying All Recrods

As other have already suggested, I would start with building a VIEW for a table to retrieve the comment fields. I believe there are instruction in the files section here. If not, contact me offline & I'll send you mine.


>>memotext

However.... I think Excel text fields are limited to 255 characters.


In case of comments, they often contain more than 255, contain odd characters, etc...

It can get messy.

So I usually use MS Access instead of Excel.

1.) build an empty table in Access

2.) add the field(s), making sure that any that will hold comments are type "memo"

3.) create an ODBC import query to select and populate your table


If you don't create the memo table/field(s) first - Access has a nasty habit of "guessing" at the datatype based on the first few rows. Ends up usually guessing it's basic text & then truncating anything beyond 255.



Has anyone encountered a problem with ODBC when connecting to the database via MS Excel?

When I pull up the memo table, all the records and fields display except for the memotext field.  That field is blank.

However, when I do a BAQ on the same table, the memotext does have data in it.

Has anyone encountered this problem before?

I seem to remember there being an issue with ODBC not being able to access data in memo fields or text fields greater than a certain character length.  Something like that.

 

Mike

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of mvissuet@...
Sent: Monday, December 09, 2013 4:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Not Displaying All Recrods

 

 

Has anyone encountered a problem with ODBC when connecting to the database via MS Excel?

When I pull up the memo table, all the records and fields display except for the memotext field.  That field is blank.

However, when I do a BAQ on the same table, the memotext does have data in it.

Has anyone encountered this problem before?


______________________________________________________________________
This email has been scanned by the Connor Manufacturing Services Email Security System.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________


______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________

Somewhat normal behavior. There are a handful of master and transactional tables that won’t simply export into Access, Excel or anything via ODBC due to Progress’ version of a memo-type field. The only workaround is using the LEFT() or SUBSTRING() functions within the query to limit the field length to less than 20,000 characters. (I think that’s the limit)

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of mvissuet@...
Sent: Monday, December 09, 2013 7:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Not Displaying All Recrods

 

 

Has anyone encountered a problem with ODBC when connecting to the database via MS Excel?

When I pull up the memo table, all the records and fields display except for the memotext field.  That field is blank.

However, when I do a BAQ on the same table, the memotext does have data in it.

Has anyone encountered this problem before?

As earlier mentioned, write your query to return the first 100 to 200 characters from the memo field.

You could also create a VIEW of the data table specifying a smaller precision for the memo field. Then simply query the view from ODBC. EpicWeb has a document on the procedure.

Thank you in advance,
[cid:image001.jpg@01CEF516.3F224820]<http://www.codabears.com/>
Calvin Dekker
630-672-7688 x1484
Email: calvin@...<mailto:calvin@...>
http://www.codabears.com<http://www.codabears.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of mvissuet@...
Sent: Monday, December 9, 2013 6:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Not Displaying All Recrods



Has anyone encountered a problem with ODBC when connecting to the database via MS Excel?

When I pull up the memo table, all the records and fields display except for the memotext field. That field is blank.

However, when I do a BAQ on the same table, the memotext does have data in it.

Has anyone encountered this problem before?



[Non-text portions of this message have been removed]