Home > IT Answers > AS/400 > Microsoft Office & AS/400 Database
Help

Question

Asked:
Asked By:
Feb 5 2008   5:56 PM GMT
Lshipley51   5 pts.

Microsoft Office & AS/400 Database


i5, Access, ODBC on i5

I am trying to bring data into Microsoft Access 2007 using ODBC. If a database has multiple members, how do you define/select the correct member in the ODBC definition? I have no problem getting the library list, and can see the files list but unable to select the member.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Feb 6 2008  3:22 AM GMT  by Bvining   4525 pts.




You should be able to call the system API Execute Command, QCMDEXC, as a stored procedure prior to the data transfer. Through QCMDEXC you would issue an OVRDBF using the appropriate MBR parameter value. The QCMDEXC API documentation can be found here.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on AS/400.

Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register