Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 migrating from access 2000 to SQL 7.0 help

Author  Topic 

clubber
Starting Member

20 Posts

Posted - 2001-03-11 : 04:55:32
It was done successfully but for some obscure reasons, all the textfields in access with data types of memo werent brought to SQL properly. Long sentences were cut off in the middle. Also, the data type in SQL is now ntext, is that appropriate? The entry can be more than 255 characters. How many characters can varchar hold? Is it maximum of 255?

I wish someone knows why memo fields werent brought successfully. I need help so bad :(

   

- Advertisement -