Access app to pull/push data from/to AS400

[Dean Slindee]

Has anyone built an Access application to push or pull data from a table
residing on an AS/400 (iSeries)?
What middleware could be used to perform the transfer(s) in either
direction?

Thanks,
Dean Slindee

 

[Tony Toews]

Has anyone built an Access application to push or pull data from a table
residing on an AS/400 (iSeries)?
What middleware could be used to perform the transfer(s) in either
direction?

From the Windows viewpoint the key is the term ODBC. One definition
is at http://www.webopedia.com/TERM/O/ODBC.html. Excel, Access and
many other programs can read data from an ODBC connection. And many
software products, including one 15 year old DOS based system have
ODBC drivers available so you can read their data.

Thus I'd go looking for software that can provide this. Now I'm sure
it exists, and almost certainly from IBM, as I've seen other folks in
these newsgroups mention the AS/400.

Tony (former AS/400 expert.)
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[aaron.kempf]

screw this MDB script kid.

use SQL Server; Access Data Projects and a linked server. it is about
1,000 times more powerful.

buy a developers' copy of SQL Server for $49 and use a freeware MS SQL
Server product; like SQL 2005 Express or MSDE.

-Aaron
ADP Nationalist