Exporting from Access to Excel
 

solution:

write your own routine using ADO
examples on www.erlandsendata.no


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?RGFu?= wrote:

Hi!

I am using the TransferSpreadsheet function (in Access) to export an
Access (2003) table to an Excel spreadsheet. The problem is fields
that have more than 255 characters are being truncated to 255 in the
new Excel sheet it created. Any ideas on how to get around this
issue?


Thanks a lot for any help!

Dan

Exporting from Access to Excel
 

keepITcool wrote ...

write your own routine using ADO

Something less drastic would be to try and do the export using a query
in the MS Access UI e.g. the following result in no truncation in
Access2003:

To create a new Excel table (workbook and/or range will be
automatically created):

SELECT
MyMemoCol
INTO
[Excel 8.0;Database=C:\TotallyNew.xls;].MyNewTable
FROM
MyTable
;

To create a new Excel table:

INSERT INTO
[Excel 8.0;Database=C:\TotallyNew.xls;].MyExisingTable
(MyExcelColumn)
SELECT
MyMemoCol
FROM
MyTable
;

Jamie.

--