255 chr limit in cell

[Guest]

I am exporting a query from Access to Excell - One of the fields is over 255 chrs long and it is being trunkated in Excel
Does anyone know a way round the 255 char limit in Excel

Thank

AlanW

 

[Dave Peterson]

I don't speak the Access, but can you split that field up into smaller pieces
(while in access).

Then retrieve each little bit and recombine?

 

[Debra Dalgleish]

Or, transfer the data with code. Use the TransferSpreadsheet method to
send the data, and specify one of the later Excel versions:

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

 

[Dave Peterson]

This code must be in the Access.

I've seen this DoCmd in other spots, but never in anything as complex as excel.
(hehehe)

 

[Debra Dalgleish]

Yes, it's in the Access. AlanW could create a macro, or add the code to
a module (just like the Excel!) Then, add a button on a form, to run the
macro or the code.

This code must be in the Access.

I've seen this DoCmd in other spots, but never in anything as complex as excel.
(hehehe)

 

[Dave Peterson]

Ahhh, the Access sounds like it might be useful to some.

Yes, it's in the Access. AlanW could create a macro, or add the code to
a module (just like the Excel!) Then, add a button on a form, to run the
macro or the code.