Import Excel into Access

V

VKG

I was having a problem importing data from Excel to
Access. The field size within Access tables was limited,
but then I found out to change the Default field type to
Memo. This worked for the most part, but I'm still unable
to get the full data from some Excel cells into Access.
It seems like text is still being cut off (limited).

I figured out a work around by adding a row ontop of the
Excel work sheet and to just include large text field
sizes, so that it's automatically detected as Memo during
the import into Access. Apparently some of the cells were
causing the import to be Text and not Memo.

Anyone know why/how I can fix this permanently?
 
J

John Nurick

Answered in another group. Please don't post the same message separately
to multiple groups because it wastes people's time and no one can see
when a question has been answered.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
How to paste this down? 3
Formatting Text from Excel 1
Import Excel to Access 1
Restoring line breaks in memo field 2
Import Excel into Access (Field size) 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
wrap text 6

Top