Export to DBase 4 question

• Gray Corpian

  Grasshopper

  Points: 15

  More actions

  October 25, 2005 at 8:17 am

  #169321

  When I use SQL Server Enterprise Manager 2003 to export a table to Dbase IV, all of the integer values are converted to real numbers. Any idea why this is happening or how I can prevent it from happening?

• David A. Long

  SSCrazy Eights

  Points: 8421

  More actions

  October 26, 2005 at 12:11 am

  #600015

  Create the "database" in dBASE IV and import the data into that table.

  Or edit the transform of the database creation defaults in EM before you run the export.

  There will always be some datatype mis-matching when transfering to foreign formats, most of the time you are safer to convert to text when in doubt.

  Andy