By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,802 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

import or link from Excel disfunction

P: n/a
Hi All,

In an Excel XP spreadsheet I have three columns of text information
several of these cells contain more an 255 characters. When I import
the information from the spreadsheet into Access XP, it chops off the
text data at 255 characters. I've tried importing to a 'New' table,
I've tried importing to an existing table where I've changed the field
type to 'memo' and I've tried linking to the spreadsheet and thern
using an append query but I can not get any more then 255 characters to
import into a table.
Any way around this?
thanks
bobh.

Jan 19 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Try converting to CSV and importing.

Linda

"bobh" <vu******@isp.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Hi All,

In an Excel XP spreadsheet I have three columns of text information
several of these cells contain more an 255 characters. When I import
the information from the spreadsheet into Access XP, it chops off the
text data at 255 characters. I've tried importing to a 'New' table,
I've tried importing to an existing table where I've changed the field
type to 'memo' and I've tried linking to the spreadsheet and thern
using an append query but I can not get any more then 255 characters to
import into a table.
Any way around this?
thanks
bobh.

Jan 19 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.