Export Memo Field to Excel

D

Dave Ruhl

Using Access 2002 I'm trying to export data linked from
an SQL Server database into an Excel spreadsheet.
Everything works fine until I try to export fields that
are datatype "memo" ('text' in SQL Server). I tried
limiting the amount of data by putting 'Left(Notes,250)'
in the query, but still get an ODBC error. Any ideas on
how I can convert this data to something Excel will
accept ? Thanks...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export to Excel 3
parse data from memo field to text field 4
Access 2003 export to excel - truncated memo fields 1
Convert Memo field ? 3
EXPORT QUery with memo field to excel, truncated data 2
Create Temp table from query, with memo fields? 7
Export to Excel - Losing Data 3
More overhead using MEMO vs. TEXT datatype? 3

Top