Access to Excel truncate - Please Help

[Mackinnon]

I was hoping that someone could possibly help.
I have been trying to export data from Access to Excel and each time I do this it transfer okay, but I find that it cuts off 1/2 the text (probably at the 255 character mark). It is with the memo fields in Access that this is happening to. I've come across this problem years ago but can't remember if I found a way around it or if I just gave in.

 

[The_Doc_Man]

I think the problem is that if you used a wizard to CREATE a table, you are hosed because the Wizard rarely chooses type MEMO for a field. And a field of type TEXT stops at 255 characters.

But if you pre-create an empty table with MEMO fields already defined and then APPEND to the existing, empty table, you might have better luck.

Particularly if only a few fields late in the table are very long, the import wizard will never figure out that it needs a memo field. I believe this appeared once in this forum or maybe I found it in an external article. The wizard only reads about the first 10 records or so in order to estimate the size and type needed for each field in the import. So if your first few records are below the 255 mark, the wizard will not assume you need it.

 

[Mackinnon]

Thanks for the advice, appreciate it.....will let you know how I get on

 

[riggsd]

I haven't been able to find a way around this same problem. I have several memo fields in Access and they are all truncated at 255 characters when I export to Excel.

What I end up having to do is copy the columns from Access, paste into MS Word, select the table in Word, copy, and paste into the exported Excel file.

 

[Mackinnon]

Thank you 'The Doc Man'

The advise given by the Doc Man was spot on when I tried it at work today. Thanks very much, you saved a lot of stress and hassle. It was easy to follow the instructions even though I had not had much experience of 'appending' before. It took about 15 minutes to do in total.

 

[gr026]

How do you create an empty table then append the table?