Extracting Long String Fied from SQL Server to Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed a report that dynamically (via ODBC) pulls data from SQL
Server back end tables. One field in SQL table is a memo text and the length
is way over 255. I need to pull this filed as is into my Access 2003 report.
So far, the memo filed shows blank in my report. Any help will be greatly
appreciated.

Thanks,
 
Jeff,
Yes, I use a query and query doesn't work either...unless I remove the field
that contains long string.

Regards,

Helal
 
Helal

I'll suggest that you post your question to either/both an Access query
newsgroup and a SQL-Server newsgroup. If the query doesn't return the
value, I doubt the report would be able to.

If the query can't "see" the long string, can you confirm that a linked
table can display it? By the way, do you have a linked table to that
SQL-Server table, or are you using a pass-through query, or are you using a
stored procedure?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Jeff,
Thanks for your suggestions. Re-your questions, yes, I use a linked table
and I am using a pass thorugh query. I can extract the long string field
using SQL Analyzer or with any other SQL programs. It's just in Access that I
can't get that field. Did I answer your questiions?

Regards,
Helal
 
Back
Top