Problems with Export to MS Access
I have tried to export a table that contains fields of datatype decimal, however, when I export the data to MS Access, the values to the right of the decimal point (scale) are never present in MS Access. The number is rounded to the nearest whole number.
I tried first creating the target table in MS Access, and even changed the field type in this table to decimal, but that didn't do the trick. I haven't tried select convert(varchar(10), column1) yet. I didn't think this would be necessary.
Also can anyone please tell me how to export data from a SQL Server table to a text file? I tried doing this but each time I tried to create the target table, using the DTS Designer, I received an MMC execption, which shut down the DTS designer. I'm running SQL Server 2000 on an old NT4 workstation.
Any help would be greatly appreciated.