Can an Excel query retrieve information from AS400 database?

  • Thread starter BeginningprogrammerLisa
  • Start date
B

BeginningprogrammerLisa

I recently discovered that Excel can run a query against a database. Rather
than import tables from Access, I wondered if I can go right to the source.
How can I create a query in Excel that will seek specific information from my
company's AS400. For instance, our AS400 (JDE) is made up of various files &
tables. I specifically want to query the table that would provide
availability.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can an Excel query retrieve information from AS400 database? 0
Creating a Chart on form from selected data in query. 0
Lookup In Excel from Access Database 0
Beginner: How do I link via ODBC from a PC into an AS400? 7
ADO connection with workgroup Access database 4
Excel VBA Query Using Access Database Hangs on 2nd Execute 8
Query from microsoft query- Excel 2007 0
References to backend table 2

Top