Post reply

''Varchar'' in sql to ''memo'' in Access

  • September 10, 2007 at 10:07 pm

    #174635

    I am exporting my sql table to the access database. My text fileds in SQL are stored as varchar(50) in SQL server 2005. but when I export the table to Access, These fileds get converted to 'memo' fields. I tried converting these memo fields in access to text field but Access does do that, throws an error message saying not enough disk space.

     

    When I try to convert these 'varchar' fields in sql to text fileds, sql throws a 'time out  ' message nad does not convert it to text.

     

    What do I do??

     

    Thanks

  • September 12, 2007 at 11:16 am

    #733217

    Why are you trying to do this?  Not sure what it is that you are trying to accomplish. 

    This is not clear, are you modifying the fields in Access or SQL Server?  If you are getting the error in Access, perhaps posting there would be more appropriate.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply