Home > IT Answers > AS/400 > Microsoft Office & AS/400 Database
Lshipley51
5 pts.
0
Q:
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.
ASKED: Feb 5 2008  5:56 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Bvining
4785 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Feb 6 2008  3:22 AM GMT by Bvining   4785 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0