RE: Microsoft Access 'TO' AS400

["Aleti, Anil" <aaleti@xxxxxxxxxxx>]

Adding to this I was wondering what happens if the input data contains
signed numeric fields with decimals(the value could be -ve). One of the
cases I had to get the sign into a different field and then write an RPG
program to manupulate the field and then get what I wanted. 

Is there any good way to get signed numeric data with decimals on to 400
files. Does Access database exports help.

Thanks,
Anil

-----Original Message-----
From: Peter Dow [mailto:pcdow@yahoo.com]
Sent: Friday, November 05, 1999 12:57 AM
To: MIDRANGE-L@midrange.com
Subject: Re: Microsoft Access 'TO' AS400


How about:

    Open the MS Access database.
    Select a table.
    Use the File menu Save As/Export option.
    Export it to an external file.
        Choose type Text (.txt, .csv, etc.)
        Click the Export button.

You'll get an Export Text Wizard where you can choose fixed or delimited
etc. Then you have your choice of FTP, some file transfer utility (e.g.
Client Access), or just copy it to the AS/400's IFS and use the CPYFRMIMPF
command.

HTH

Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax


----- Original Message -----
From: Eric Sundell PMI <ESundell@delta.org>
To: <MIDRANGE-L@midrange.com>
Sent: Thursday, November 04, 1999 12:20 PM
Subject: Microsoft Access 'TO' AS400


> Hey Everyone!
> I seem to remember a while ago in an article or something that explains
how
> to
> use Access for format a database to send to a AS400 and I just can't seem
to
> remember where.  I know I can use ODBC, but don't wanna, scares me. Anyone
> heard
> of this or know how to do it?
>
> Thanx
> Eric Sundell
> AS400/PC Specialist
>
> "Of course it makes sense that every facet of our daily lives
> should depend upon the position of celestial bodies hundreds
> of millions of miles away." - Calvin and Hobbes
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---


__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---