If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
Re: convert a PF in AS400 to Access database (.MDB).
I second what DMW said: from within Access, use a VBA macro to connect to the PF through OLE DB (there is a provider for this in iSeries Access for Windows), and output the retrieved data to an Access table.
"Time passes, but sometimes it beats the <crap> out of you as it goes."
i'd just use the "Link table" option DMW suggested...no macro required.
I've never had success with those, personally. Although one of my colleagues used to use them a lot...until I showed him how easy it was to copy and edit a macro, that was already written, from another db.
"Time passes, but sometimes it beats the <crap> out of you as it goes."
Re: convert a PF in AS400 to Access database (.MDB).
I dont have access here or I would give you screen shots.
First, use ODBC administation program. This is under the admin or ISeries access groups.
Make a system DSN , select teh ISeries Access ODBC drive.
Go to Access. You can make a table and select "other " as the source. You can then select the system dsn that you just made and then drill down to the file.
Hunting down the future ms. Ex DeadManWalks. *certain restrictions apply
if you are running client access you should already have
a data source defined if not then I can give you screen
shots of what you need.
once created the only thing you should have to
worry about is the library list.
Its found under the server tab on the access for
Windows ODBC Setup. you may have to mess around
to get this all set correctly...again just let us know
where you get stuck.
Once this ODBC connection is setup, then its all downhill.
(see images)
Just open access, then select Open
then on the "files of type" drop down go to the very bottom and
select ODBC database.
Then just find you ODBC connection you created above
then a list of all tables in the library list you entered
will be displayed... select one .... then your prompted for
fields in that table....
then that is Done!
jamie
Attached Files
All my answers were extracted from the "Big Dummy's Guide to the As400"
and I take no responsibility for any of them.
Re: convert a PF in AS400 to Access database (.MDB).
Please don't use ODBC. It is the RPG III of Windows connection technology. Use OLE DB instead. It's the RPG/FREE version, and you don't have to set up a persistent connection on the user's PC.
"Time passes, but sometimes it beats the <crap> out of you as it goes."
Comment