Hello,

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.

Thanks,

Sam

Hi
You try to check it on other database.If it still to have an error, that things mean that your DTS have error.



L.V.L

Maybe you could link the SQLServer table from Access?
And then copy/paste the rows...?

Just a thought...

HtH

Jonax

I had similar problems, solved them by going through the C:\Program Files\Microsoft SQL Server\80\Tools\Binn directory and manually registering all the dlls in there.

hth
Phil