ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

convert a PF in AS400 to Access database (.MDB).

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • convert a PF in AS400 to Access database (.MDB).

    How can I convert a PF in AS400 to Access database (.MDB).

    Can anyone give me an idea.?

    Thanks,
    Mini

  • #2
    Re: convert a PF in AS400 to Access database (.MDB).

    If you just want to use the file, have and odbc source set up and from access you can link to the table.

    If you want to import the file, you can do the same and use some vba to read the file and load it into access.

    Or you could use ftp then vba to import the file, or client access data transfer then vba to import the file.
    Hunting down the future ms. Ex DeadManWalks. *certain restrictions apply

    Comment


    • #3
      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."

      Comment


      • #4
        Re: convert a PF in AS400 to Access database (.MDB).

        i'd just use the "Link table" option DMW suggested...no macro required.
        I'm not anti-social, I just don't like people -Tommy Holden

        Comment


        • #5
          Re: convert a PF in AS400 to Access database (.MDB).

          Originally posted by tomholden View Post
          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."

          Comment


          • #6
            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

            Comment


            • #7
              Re: convert a PF in AS400 to Access database (.MDB).

              You can find the odbc data source under:

              start/programs/administrative tools/Data sources (ODBC)

              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.

              www.code400.com

              Comment


              • #8
                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

                Working...
                X