I am attempting to pull tables from a JD Edwards install
on a as400. I am using Client access odbc driver, and
each time I do the copy of the table I get screwed up
fields where the date fields are supposed to be. In fact
the date fields are converted to decimal. thus 9/9/2003
becomes 101232. any ideas how to set up this conversion??

maybe use a transformation table storing the date as varchar and then
convert to dt in the next step
"Tim O'Keeffe" <tokeeffe (AT) symmons (DOT) com> wrote