Importing access into SQL Server DB

• potucekj

  Default port

  Points: 1414

  More actions

  May 6, 2003 at 7:11 am

  #159938

  Getting mulitple insert errors for specific rows and columns when importing an access DB into a SQL Server 2000 DB: Data overflow. invalid character value for cast specification.

  any ideas?

• jpipes

  SSChampion

  Points: 12230

  More actions

  May 6, 2003 at 8:48 am

  #456288

  Please post the schemas for both the access table and the sql server table. This will help identify likely troublespots. Thanks.