Import from Excel Truncates Memo Field to 255 Characters. WHY?????

[PWD]

Good afternoon. It seems that there have been many people asking this question over the years, but nothing that has given ME an answer. All I want to do is import from an Excel spreadsheet to a Memo field in an existing table using Access 2007 (but a .mdb database - if that makes ANY difference!). Even if I just try to walk through the Import Spreadsheet Wizard - to a NEW table, it only shows the first 255 characters.

If anyone has a solution, I'd be very glad to hear it.

Many thanks,
Des.

 

[dhookom]

You might want to look through Ken Snell's pages

Duane
Hook'D on Access
MS Access MVP

 

[PWD]

So I had a thought, "Start again with a brand new, blank database & see what happens."

If I Import & Create the tables from scratch, it seems to be OK (so far)!!

Des.

 

[PWD]

But now it's not

Des.

 

[PWD]

SOOOOOOO!

I went to Ken Snell's pages & had a look at

Write Data From an EXCEL Worksheet into a Recordset using Automation (VBA)

and, ahem, that seems to have done the job.

I'll confirm later.

Is there a "best" way of looping through an array of Worksheets & Tables with this code?

Many thanks,
Des.

 

[dhookom]

You might want to search the web on your question. If you want Excel code to loop through all the worksheets in an Excel field, you might want to post in the VBA Visual Basic for Applications (Microsoft) forum.


Duane
Hook'D on Access
MS Access MVP