Odp: odbc

[Dariusz B³a¿ków <Dariusz.Blazkow@xxxxxxxxxxxx>]

Hello !

It works:
1. Transfer file from AS/400 as text - i'm using reflection session software
(in menu is option to transfer data from or to AS/400 - use this) - in
Client Access is the same solution
2. Open empty Excel (i'm using Office 97) and open downloaded txt file --->
excel run convert wizard and save as *.XLS
3. Open Access and make new bdatabase --> click on import table and select
*.xls file ---> it is ALL


Best regards Dariusz Blazkow
POLAND

----- Original Message -----
From: <Imaginor@aol.com>
To: <RPG400-L@midrange.com>
Sent: Saturday, May 06, 2000 6:18 PM
Subject: odbc


> 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
> Kiss Products, NY
> +---
> | 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
+---