RE: iSeries & MS Access Can't Export

Jeff,

One exasperating part of trying to export CSV from a Microsoft product into
the iSeries is that it NEVER seems to put quotes around character data.
That means that if ever you have a string with a comma in it, Microsoft
seems to think it's two fields, and if you're trying to send this to the
iSeries, suddenly none of your data is going into the correct fields.  

Another problem for me is that Excel seems to determine the data-type for
each cell, regardless of your "Format Cells" setting.  I routinely have
columns that carry numeric digits as character data (for example, Zipcode is
10A) and for no obvious reasons, I'll sometimes get data mapping errors
telling me that I can't put numeric values into a character field.  No
matter what I try, I can't get Excel to export the value the way I want.

CSV works great to get data off the iSeries and into a spreadsheet, but it
sucks going the other way.  

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Jeff Silberberg [mailto:jsilberberg@xxxxxxxxxxxxxx]
Sent: Monday, October 13, 2003 2:10 PM
To: Midrange Systems Technical Discussion
Subject: Re: iSeries & MS Access Can't Export




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.