Access -> Excel: How to export fields > 255 characters

Dear newsgroup

I have seen that there are a couple of similar threads in other newsgroups
and there are also some documents in the ms knowledgebase. Anyhow I would
like to know whether it is possible or not to export data from access fields
> than 255 characters.

My problem is that I have a database containing some product information.
Now I have to deliver some of the data to an external marketing platform and
they are using excel sheets as standardized data exchange format. I need to
put a longer description into one cell in this excel sheet but I only can
store 255 characters. But if I continue to enter text manually, this works.

My question is:

How can I export data from Access to Excel if the contents of a database
filed are longer than 255 characters? I know that using a CSV-file for data
exchange would be smarter but I cannot change the situation.

Has anyone a good idea?
I'm looking forward to any useful input!

Kind regards
Gabriel

Not elegant, but a suggestion might be to export half the data to one cell, the other half to another, contatinate (=A1&A2) in to target cell and then delete the data in the temporary cells.

Or perhaps, you could export the data as two strings (cell.value = string1 & string2).

To be honest, don't really know but this is what popped in to my mind as possible things to try.

HTH

Hello Gabriel-

Have you tried using Data>Import External Data>New Database Query (wording
varies depending on version) to query the Access file directly? I'm not sure
this will solve the problem, but it will give you more efficiency than
dumping to a text file & importing it to Excel.

HTH |:>)

"Gabriel Martin" wrote:

> Dear newsgroup
>
> I have seen that there are a couple of similar threads in other newsgroups
> and there are also some documents in the ms knowledgebase. Anyhow I would
> like to know whether it is possible or not to export data from access fields
> > than 255 characters.
>
> My problem is that I have a database containing some product information.
> Now I have to deliver some of the data to an external marketing platform and
> they are using excel sheets as standardized data exchange format. I need to
> put a longer description into one cell in this excel sheet but I only can
> store 255 characters. But if I continue to enter text manually, this works.
>
> My question is:
>
> How can I export data from Access to Excel if the contents of a database
> filed are longer than 255 characters? I know that using a CSV-file for data
> exchange would be smarter but I cannot change the situation.
>
> Has anyone a good idea?
> I'm looking forward to any useful input!
>
> Kind regards
> Gabriel
>