Export Memo Field to Excel

  • Thread starter Thread starter Dave Ruhl
  • Start date Start date
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...
 
I forgot to mention that I only get the error when
using "SELECT DISTINCT"
 
You must log in or register to reply here.

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

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

Back
Top