Extracting data from Oracle Table to Access Table
Posted: Fri Nov 14, 2003 12:56 pm
Hi All,
We are trying to extract all the records from one of our Oracle tables using
some filter through the Transform to be ported into the Access Tables, but
were facing problems which I am listing out below :
1. Mismatch in Data types:
2. Expected and Actual column size mappings
Now here as, I have tried to regularize the data type mismatch by
synchronizing the data types at both the ends, but the 2nd problem still
exists and I am not able to find a solution, especially with those columns
where the column size in the Oracle table is "1" and for the same column in
Access Table is "5", now here while writing data into the Access Table it is
not allowing me to write into the Access Table which is quite clearly
frustrating as at the time of creation of the table we had not specified any
length and it has taken the default length of 5 for Small Integer type of
data.
Here I am not able to understand why is Access getting adamant on filling
the complete length of the column where as it can accept 1 digit instead of
5.
I hope I am clear while explaining the problem. Please, please, please do
help me out in this as early as possible.
Thanks & Regards
Kedar
We are trying to extract all the records from one of our Oracle tables using
some filter through the Transform to be ported into the Access Tables, but
were facing problems which I am listing out below :
1. Mismatch in Data types:
2. Expected and Actual column size mappings
Now here as, I have tried to regularize the data type mismatch by
synchronizing the data types at both the ends, but the 2nd problem still
exists and I am not able to find a solution, especially with those columns
where the column size in the Oracle table is "1" and for the same column in
Access Table is "5", now here while writing data into the Access Table it is
not allowing me to write into the Access Table which is quite clearly
frustrating as at the time of creation of the table we had not specified any
length and it has taken the default length of 5 for Small Integer type of
data.
Here I am not able to understand why is Access getting adamant on filling
the complete length of the column where as it can accept 1 digit instead of
5.
I hope I am clear while explaining the problem. Please, please, please do
help me out in this as early as possible.
Thanks & Regards
Kedar