Re: odbc

["Hector Sanchez" <hsanchez@xxxxxxxxxxxxxxxxxxxxx>]

I have done this many a times with Access.  I would not sent to Excel.  You 
have to make sure that you have the ODBC Drivers installed for Client Access.  
Then basically, you would link to an external Database in Access.  Access just 
ends up reading the file directly from the AS/400.  You can do some really nice 
reporting.  

Hector Sanchez
Driscoll Childrens Hospital
Corpus Christi, TX

>>> <jpcarr@TREDEGAR.COM> 05/06/00 10:13PM >>>



>I would like to download a '400 physical file to a microsoft access data
base
>file. An associate of mine informed me that when using client access, it
will
>take 2 or 3 steps (1. transfer data to a text file...2. map to an excel
>file...3. import to access). Using an odbc connection and definition, can
I
>map and download directly into access? if so, please explain the steps.
Thank
>you.
>Richard Deutsch


How about going into Excel,  Click on the DATA tab, Select "Get External
Data",
Select "Create New Query",  Pick your AS/400 as a data source,  key in the
query
request and it will map straight into the Excel Spread Sheet.

Download?  we don't need no stinking download.

Gee,  The AS/400(aka DB/400)  is just another data source.


John Carr

http://www.400school.com/pstsql.htm 







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

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

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