Export SQL table to Access - field type conversion problem

• Don Schafer-457775

  SSC Journeyman

  Points: 80

  More actions

  March 14, 2008 at 12:59 am

  #120510

  I'm using 'Export Data...' in Management Studio to export a SQL table to Access.

  The varchar fields are being automatically converted to longtext.

  Is there a way to configure it so a varchar will convert/stay a varchar without having to manually reset every field?

  Any help would be greatly appreciated.

  Thanks

• shamas saeed

  SSC-Addicted

  Points: 458

  More actions

  March 14, 2008 at 3:35 am

  #789503

  Hi

  Use Access import vizard and this problem will not happen using DSN conntion

• Don Schafer-457775

  SSC Journeyman

  Points: 80

  More actions

  March 15, 2008 at 10:48 am

  #790034

  Thanks Shamas, that did the trick. Now I just need to get up to speed with SSIS.