The text is too long to be edited Error Message

[Alice]

What exactly is Access trying to tell me in this Error Message? I am trying to export (copy and paste into an Access table) from an Excel spreadsheet. I got a different error message when using the Get External Data feature, so I thought I could just copy and paste into a table that I set up with the correct number of fields (all 255 characters in length). One of my Excel fields is pretty long. Too long for Access?

Thanks.

Alice.

 

[Norman Yuan]

If some columns in Excel sheet contain more than 255 characters, you may
want to set corresponding column (field) in Access table as Memo type
instead of Text type, which only allows 255 characters.

What exactly is Access trying to tell me in this Error Message? I am

trying to export (copy and paste into an Access table) from an Excel
spreadsheet. I got a different error message when using the Get External
Data feature, so I thought I could just copy and paste into a table that I
set up with the correct number of fields (all 255 characters in length).
One of my Excel fields is pretty long. Too long for Access?

 

[Raghu Prakash]

Hi Alice,

CAUSE
This issue may occur when you try to type data in a field that has been
upsized from the Memo data type in Microsoft Access to the SQL Server nText
data type.
RESOLUTION
To resolve this issue, modify the data type from nText to Text or Varchar.
To do so, follow these steps.

NOTE: To perform the procedure listed later in this article you must have
appropriate permissions to modify database objects (db_ddladmin or
db_owner).


Start SQL Server Enterprise Manager, and then locate the server where the
database is located.
Expand the Databases folder, double-click the database name, and then click
Tables.
In the right pane of Enterprise Manager, right-click the table where the
nText datatype field is located, and then click Design Table on the
shortcut menu.
Under Data Type, click the field that you want to modify, click the down
arrow, and then click either Text or Varchar data type.
Close the Design Table dialog box. Click Yes to save the changes that you
made to the table design, and then quit SQL Server Enterprise Manager.
Start Microsoft Access, and then open your database application.
Click Tables, and then delete the linked table that contains the field that
you modified in step 4.
Re-link the table. To do this, follow these steps:
On the File menu, point to Get External Data, and then click Link Tables.
In the Files of Type box, click ODBC Databases().
Click an existing DSN or click New to create a DSN that points to the SQL
Server or MSDE that contains your table. Click OK.

NOTE: The server may prompt you to log on. If you do not know the user ID
and password, contact your system administrator.
In the Link Tables dialog box, select the table that you want, and then
click OK.

Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.