Access to Excel Exporting Question

[kkernohan]

I have a bunch of tables in Access. One of the fields has a significant amount of characters in each cell (>30,000) When I try to export this table to excel the extra characters get cut off due to the cell limitations by excel.

Im looking for a way to either splice the cells in access or somehow get around the cell limitations in excel. Is this possible to do using SQL or query so I can replicate for many rows/tables?

 

[Norie]

Silly question maybe, but why do you have fields with 30K+ characters in them?

What type of data is it?

Perhaps you should be considering parsing in some way anyway, ie not just for export/import.