Re: iSeries & MS Access Can't Export

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Am coming in to this late, maybe. Have you looked at using a logical that 
redefined the data type for the import/export to Access?

HTH

Vern

At 03:09 PM 10/13/2003 -0400, you wrote:


> I have done more trouble shooting and it appears this related to the fact 
> that the "Field Size" in the table created by the Import is
> "Decimal" and the Export / Import filters from MS do not like this.  Other 
> than the obvious of changing the Field Type to "Long Integer"
> does anyone have a tip on how to convert the data element so Export will 
> function.
>
> I have tried setting Format to General & Fixed, neither helped ?  Do I 
> need to put a Function behind the Format ?
>
> TIA,
> JMS..
>
> At 11:01 AM 10/8/2003, Jeff Silberberg wrote:
> > Morning All,
> >
> >         Have a strange problem that I hope someone here has resolved.
> >
> >         Created an Empty mdb with Microsoft Access 2K
> >
> >         Imported Contents of iSeries PF into the MDB. (Created an 
> > Populated Table no Problem.)
> >
> >         Then tried to get additional data two days latter and import 
> > using CSV created with a CPYTOIMPF. But when I try and import this 
> > resulting CSV,
> >         I get an error message, and in fact if I try and export the data 
> > from working MDB table to a CSV, I also get an Attribute error message.
> >
> >         Limited help messages appeared to indicate that my decimal 
> > representation in the systems "regional" settings did not match Access. 
> > But I don't see any obvious problems.
> >
> >         Anyone seen / know how to resolve this ??
> >
> >         TIA,
> >         JMS...
> > _______________________________________________
>
> Jeffrey Silberberg
> CompuDesigns, Inc.
> Atlanta, GA. 30350
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.