• Subject: Re: Microsoft Access 'TO' AS400
  • From: "Peter Dow" <pcdow@xxxxxxxxx>
  • Date: Thu, 4 Nov 1999 22:56:47 -0800

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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact [javascript protected email address].