Re: Access database

["Chuck Morehead" <cbmorehead@xxxxxxxxxx>]

Dave,

This is a little bit of a rehash from other responses, but here is what I
use:

1)  Create an ODBC datasource pointing to the library your files are in.
2)  In Access go to File, Get External Data, Import
3)  Change the "Files of Type" drop-down box to be "ODBC" and then choose
the datasource you created in step 1.
4)  Choose the file you want and the file description and data are pulled
into your Access database.

Be careful about Import v.s. Link - Linking to the table can give you direct
access to your AS/400 file from Access.  I.e. Linking pulls the file
description into Access and utilizes your AS/400 data; whereas importing
pulls both the file description and data, basically giving you a snapshot of
the file.

Chuck

----- Original Message -----
From: "Dave Snyder" <dsnyder@blcnet.com>
To: <midrange-l@midrange.com>
Sent: Friday, June 15, 2001 10:51 AM
Subject: Access database


> What is the easiest way to get a file from the AS400 and put it into an
MICROSOFT ACCESS database format for a p/c? Are there any utilities on the
AS400 to assist in this?
>
>
> Dave Snyder
> Systems Analyst
> Sterling Financial
> Phone: 717-735-5876
> dsnyder@sterlingfi.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
+---