Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

AS/400 Queries from MS Access 97

0 views
Skip to first unread message

John Lambert

unread,
Jan 1, 1999, 3:00:00 AM1/1/99
to
Anyone querying an AS/400 from Access97? Would like to entertain dialog
concerning date formats and possible conversion methods when bringing data
over to PC. Thanks

John Lambert

jlam...@wb4uds.org

Eddie W. Stroud

unread,
Jan 1, 1999, 3:00:00 AM1/1/99
to

We've done this quite a bit of this and finally wrote some code to get back
and forth from the Microsoft date format to a MMDDYY fixed format the AS/400
could use. I'd be glad to share if you give me a day or 2 to remember where
it is. We also had a bit of problems with keeping decimal points in the
proper place in a fixed format.


John Lambert wrote in message <368c7...@news-out2.newsnerds.com>...

Eddie W. Stroud

unread,
Jan 1, 1999, 3:00:00 AM1/1/99
to
Also, are you doing this via ODBC or import/export and file transfer?

Weyerhaeuser

unread,
Jan 4, 1999, 3:00:00 AM1/4/99
to
I've been working on a front end using Access 97 to a combination AS/400 -
Access backend. What do you mean by "bring data over to PC"?

SMDavis

John Lambert <jlam...@wb4uds.org> wrote in article

0 new messages