Guys, I got a bit of problem with data types.
I have an Access Database which contains various amounts of data stored on a daily basis. The format of this data in Access is in Real.
I have written a web front end to allow users to query this data in vb.net, however, the data is copied via a DTS package from Access to an MS SQL server with the same data is stored in a Double. I've noticed after the copy has finished that the data has a different precision in MS SQL, just a few points off, but its causing me problems...
I need to keep the data in its original format without any alterations. Any idea's how to do that?
I have an Access Database which contains various amounts of data stored on a daily basis. The format of this data in Access is in Real.
I have written a web front end to allow users to query this data in vb.net, however, the data is copied via a DTS package from Access to an MS SQL server with the same data is stored in a Double. I've noticed after the copy has finished that the data has a different precision in MS SQL, just a few points off, but its causing me problems...
I need to keep the data in its original format without any alterations. Any idea's how to do that?