RE: odbc

I'd love to here this! Lay it on me, Gade! (unless it's using a mirroring
product)

Brad

> -----Original Message-----
> From: Gade_R_Reddy@consecofinance.com
> [mailto:Gade_R_Reddy@consecofinance.com]
> Sent: Monday, May 08, 2000 11:31 AM
> To: RPG400-L@midrange.com
> Subject: RE: odbc
> 
> 
> 
> Do you have access to microsoft Sql Server???.
> 
> If you have, there is a really easy way to transfer data from 
> As400 to Sql
> Server & then to your Access. I do this all the time, Believe 
> me its really
> simple!!!!.
> 
> Let me know.
> Gade.
> 
> 
> 
> 
> 
> "Bale, Dan" <DBale@lear.com>@midrange.com on 05/08/2000 08:58:33 AM
> 
> Please respond to RPG400-L@midrange.com
> 
> Sent by:  owner-rpg400-l@midrange.com
> 
> 
> To:   "'RPG400-L@midrange.com'" <RPG400-L@midrange.com>
> cc:
> Subject:  RE: odbc
> 
> 
> A word of caution:  Excel can turn a field defined as 
> alphanumeric on the
> AS/400 to a numeric if the first few records it interrogates finds
> left-justified numbers in the alpha field.  This won't happen with an
> Access-ODBC load.
> 
> Also, I'm wondering why almost everyone responding is talking 
> about using
> Excel.  Richard made it clear that he needs to get the data 
> into an Access
> database.  ODBC will easily get it there.
> 
> The steps to setup an ODBC transfer in Access 97:
> 
> 1) In Access, in the database window, activate the Tables 
> tab.  Click on
> New.
> 2) In the New Table window, click on Import Table, then click on OK.
> 3) In the Import window, click on the Files of Type: to drop 
> down the list
> of file types.  At the bottom of the list is ODBC databases; 
> click on that.
> 4) The Import window disappears and the Select Data Source 
> window appears.
> Click on the Machine Data Source tab.  If an appropriate Data 
> Source has
> been defined, go to step 8.  If not, click on New and 
> continue with step 5.
> 5) In the Create New Data Source window, I usually select System Data
> Source.  (This is a matter of whether you want anyone else 
> who logs onto
> your PC to be able to use this link.)  Click on Next.
> 6) It's still called the Create New Data Source window, but 
> now you have a
> list of ODBC drivers to choose from.  Depending on your 
> setup, select the
> appropriate driver for the AS/400.  In our environment, we 
> use RUMBA AS/400
> Optimized Server (32bit).  Click on Next.
> 7) At this point, you're on your own, because the following 
> screens are all
> specific to the driver you're using.  If the RUMBA driver is any
> indication,
> it should be fairly easy to finish from here on out.  You 
> have to know your
> AS/400 system name.  Also, you'll have to type in either a 
> library list
> (generally, just the library you want to get the data from) or a job
> description name (that will supply the library list).  Keep 
> this list as
> short as possible because when you get to the point where you 
> select the
> file you want to import, it's going to list *every* file found in the
> library list used.
> 8) Most likely, you'll get a Client AS/400 Sign-On window.  
> Fill in and
> click on OK.
> 9) In the Import Objects window, you'll see a list of all the 
> available
> tables (files).  Select the desired file and click OK.  At 
> this point, the
> data starts getting imported into Access.
> 
> HTH,
> - Dan Bale
> 
> > ----- Original Message -----
> > From: <Imaginor@aol.com>
> > To: <RPG400-L@midrange.com>
> > Sent: Saturday, May 06, 2000 11:18 AM
> > 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
> +---
> 
+---
| 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
+---