Why my import data from access to sql database is incomplete?

[mitchikoy15]

I'm having trouble in importing data from my former database which is access to my current database MS SQL.

The data type of the field form access table is MEMO type while the field where to import data/rows is nvarchar(max).

The users of the program uses Bullets and Numbering type of inserting.

I used the import tool in MS SQL to import the rows form access database to transfer it to my newly database.

How am I going to solve this problem? Please Help me..

Thank you in advance...
have a nice day... God bless us.. =))

 

[kray4660]

I think this is the wrong forum. Not sure which one would be correct. This forum is for issues with accessing data through Crystal Reports.