Manage Learn to apply best practices and optimize your operations.

Using CA to import data

I am using the Client Access V5R1 ODBC driver to establish connectivity so that I can import data to Microsoft Access. When I go into Access, the only thing I can see when I attempt to import is library QGPL. I need to see other libraries. I can see all libraries on my PC, but not on another. Do you know why?
The list of libraries displayed to the end user via ODBC depends on the library list attribute of the ODBC data source. In order to set it differently, set your library list in the DSN. For more details, click here.


Visit the ITKnowledge Exchange and get answers to your connectivity questions fast.

The Best Web Links: Tips, tutorials and more.

PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.

Dig Deeper on Data backup, storage and retrieval on iSeries

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.