Transfer Spreadsheet field missing data

[Mary]

I set up a macro to transfer the results of a query to Excel. The macro
transfers the data, however one of the fields seems to be limited and only
transfers part of the results. There are 489 characters including spaces in
the particular field I am looking at in Access. Only 255 transferred. Is
there a way around this? Thanks, Mary

 

[Ken Snell [MVP]]

If you use the File | Export method, that uses an old version of EXCEL that
could not handle more than 255 characters in a field. Use a macro or VBA
code to do the TransferSpreadsheet action -- it will export the entire
contents of the field. Specify EXCEL 97 or higher as the version in the
EXCEL version argument of this method.

 

[Ese]

I have a macro in access which I would like to get the output exported to
excel. I am trying to use the TransferSpreadsheet function but I can't seem
to get the full path name. I want the output table to go to a specific excel
file, tab and range but I do not no how to write the full path and range in
the macro.

An example of what I need will really be helpful. Thank you.