HI. I have been asked to convert an Access Database into a sql 2000 database. One of the field types in the access database is 'hyperlink'. I have looked into BOL and I do not see any data type comparable. Is this even possible?
There is no hyperlink datatype as what you have in MS ACCESS you have to convert this datatype to varchar and use your application logic to convert that to hyperlink field in the application.