Access to Excel memo-type field transfer

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

Guest

Is there a special formatting I can use in an Excel spreadsheet so it can
accept the full text from an Access query that has a Memo field-type column
(called Resolution) which can sometimes have more than 255 characters. In
Access, I can display the entire content of the column, but when I transfer
to Excel, the text gets cutoff. I have tried formatting the Excel column as
"Text" but to no avail.
 
I am having the exact same problem right now. I have tried Exporting the
query, as well as choosing from Tools to Analyze the results in Excel, but
both cut off the text. Choosing a single cell in Access and copying and
pasting the text within the cell into Word allows for the entire text to come
through.

If anyone has more information, it would be greatly appreciated.

Stacie
 
In Access, use the TransferSpreadsheet method to send the data, and
specify one of the later Excel versions. You can do this by creating a
macro, or writing some code, e.g.:

'======================
Sub SendTableToExcel()
DoCmd.TransferSpreadsheet acExport, _
acSpreadsheetTypeExcel9, "tblCustomers", _
"c:\Data\MyExcelFile.xls", True
End Sub
'===========================

Then, add a button on a form, to run the macro or the code.
 
Back
Top