LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieve data from excel database Vanya Noble Excel Discussion (Misc queries) 0 November 12th 09 12:51 AM
Excel and AS400 DB2 database Esperanza[_2_] Excel Programming 0 December 28th 04 09:06 PM
Function To Return Info From As400 Database Robin Flores Excel Programming 0 October 21st 04 08:59 PM
DDE to Query AS400 DB Joseph[_26_] Excel Programming 0 February 9th 04 10:46 PM
Query AS400 and unknown character D.S.[_3_] Excel Programming 6 December 2nd 03 11:57 AM


All times are GMT +1. The time now is 11:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"