Importing SQLite to MS-Access: Datatype mismatch between the columns

I imported a SQLite DB into MS-Access using ODBC and it was successful except for one column. One of the columns in SQLite DB was of 'Integer' datatype but it contained a string since datatypes are flexible in SQLite. But in the imported MS-Access DB, the column corresponding to that particular datatype is blank. I assume that the Access DB was expecting a integer datatype and not accepting a string. The following is the table structure:

CREATE TABLE test ( num INTEGER, name TEXT, script INTEGER NOT NULL );

I have problem with the column 'script'. I am not allowed to change the datatype here so is there any solution that I can workout in Access?