Field too small to accept the amount of data

G

Guest

I am moving the Access database to Sql server. On conversion of one of the
queries I get the message "Field too small to accept the amount of data you
attempted to add". When I exclude one of the fields from the query it works
fine. But I never had any problems when the backend was Access.

any suggestion?

Thanks

CS
 

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

I am trying to write a small query which will remove the duplicate 1
Union Query & Error 3163 2
Field too small? appending to yes/no field 6
"Field is too small ..." when running append query in Access 2003 7
Cannot export Query to Excel 4
Error when creating make tables 1
The field is toosmall to accept the amount ofdata you attempted to 2
"The field is too small..." error coming up on Select query. 6

Top