Can an Excel query retrieve information from AS400 database?
 

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.