I'm not sure what to do on this one. I have an access database populated with data that has 5-6 memo fields. I'm trying to move the database to SQL 2k and I'm having a problem with the memo field. At first I thought I would just make it a varchar but they have limits of 8000 characters and when I try to import it's telling me there records (I don't know how many) that are over the size limit. Is there an SQL data type that will take large strings like memo fields? Thanks, Brian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182983 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
