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

exporting report fields to spreadsheet 1
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Create Temp table from query, with memo fields? 7
Import memo fields from Excel spreadsheet 1
Exporting files from Access into Excel 1
Convert a Number field to Autonumber? 15
Exporting to word misses off data 4
column header needs symbol 2

Top