RE: Link AS400 database wirh Access Database

["Chaudhary, Sachin \(GE Equipment Services, Consultant\)" <sachin.chaudhary@xxxxxx>]

1. Can't we choose to do this conversion on MS Access? Something like we FTP 
the data to PC and then choose to open the file in Access?
2. Even if we can do this I wonder how can we select a library and a file 
member??

Rgds,
Sachin

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Gary Monnier
Sent: Thursday, January 20, 2005 6:15 PM
To: Midrange Systems Technical Discussion
Subject: RE: Link AS400 database wirh Access Database


Access will have to perform a data conversion before your new query can
run.  You may use more CPU converting EBCDIC to ASCII that your original
query used.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Chaudhary, Sachin
(GE Equipment Services,Consultant)
Sent: Thursday, January 20, 2005 4:09 PM
To: Midrange Systems Technical Discussion
Subject: Link AS400 database wirh Access Database


Hi

I want to run query on one of the largest files on AS400. Since it eats
up a lot of CPU , I thought of Linking the file to Access database using
ODBC connection. 
I will run the query in Access, and leave it overnight so that AS400 CPU
usage is not affected at all.
However when I chose link table in MS Access , and try to select ODBC
Databases, it offers selection of files from only 2 libraries PSCOMMON
and QGPL!. There is no browse button so that I can select a particular
production library, neither can I select any particular member of the
file?
Isn't this weird??
Is there any place where I can get some info about AS400-MS Access??

Rgds,
Sachin

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.