upsizing access database to sql server 'error

[hfs]

hey,

I am trying to upsize the access database to sql server ,i have an odbc connection and when i try to move the tables,all the data is moving except one table "tblproductinfo" i have attached the table data and error.Need Help ///thanks in advance

 

[Pat Hartman]

We need to see how the columns are defined. Upload a database with only the problem table.

There are a couple of column names that might conflict with reserved words. Try to use compound words for column names. You are less likely to run into conflicts.

Are the True/False fields actually text or are they y/n fields. Access allows y/n fields to actually be tri-state so y/n/null is possible but the Boolean datatype they are converted to only allows two states. Null is invalid so you may need to change the data type to integer instead of y/n. You can still use the field in a checkbox.