Exporting Access 2000 reports to Excel

  • Thread starter Thread starter Dino
  • Start date Start date
D

Dino

Using an Access database to link to SQL tables, from this reports are
run. these reports have a number of fields and a rather large
comments section. When the report is exported to Word, all
information can be viewed however, if exported to Excel at least half
of the comments in the comment field are excluded.

Can anyone help!!
 
If I remember the issue with this problem is that when exporting a memo
field that may reside other than the end of the field list, the data in the
memo field gets truncated. I vaguely remember reading that placing the memo
field at the end generally will work. However, I also vaguely remembering
that you may have to write code to export the data in the memo field in 100K
increments and append each 'chunk' to each other. See 'Append Chunk' or
exporting BLOB data in Access help.
 
All fields exported to Excel 97 and lower will be
truncated to 255 characters. Therefore, when exporting to
Excel make sure you reference the Excel version higher
than 97, by putting an 8 in the commandline for
transferring the database to Excel as follows:

DoCmd.TransferSpreadsheet acExport, 8, strQry, strAll,
True, ""

whereby the 8 stand for the Excel version (5 means 97 or
lower), strQry stands for the name of the query creating
the dataset you want to export, and strAll stands for the
name of the Excel file you want to create.

Hope this helps, at least it does for me.

Bakema
 
Back
Top