|
rrb
SQLTeam Poet Laureate
Australia
1478 Posts |
 Posted - 08/12/2002 : 19:32:11
|
I assume you're using DTS? When you create your transformation, double-check the table it's going to create, because by default, the type assigned for access float appears to be int.
Open your package, double-click on the transformation in question and go to the Destination tab, check the datatype for the column in question.
Now that the destination table already exists, you may want to delete and re-create that transformation and table so that you can specify "float" rather than integer.
--
I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
Import float from access
