Re: Help Me

Hi,

We use Client Access(which includes file transfer to and from a PC) from
IBM,  for simple Queries, that works fine.  When it is more complicated,
you can first use Query 400  to create a file on the AS400 and afterwards
you can transfer it to the PC  using Client Access file transfer.

Succes  from sunny Holland.

Lucas

At 07:35 AM 03/09/2002 +0000, you wrote:

Hi...

I saw ur Articals in net.. I have Little Problems with Mapics.
we are using Mapics with our AS400. but My managment need some Report form
that in MS Execel.

we have to Build up  tool  to Retrive data (Read only) from Mapics DB to
windows Base Application ( Execel, Access..txt).

So I'm Visual Basic Software Developer. I need a Develop Simple Application
to Get data From Mapics to Windows. I'm Planning to use ODBC  in windows.

I want to Connect Mapics DB to via ODBC and Take Files Name and Fileds,
Type... ect.. Then   I need to Quary with some Releation ( Like ..Select *
From Item..) and send that Quary to DB and Take Record set. that record set
I can Send to MS Execel ar Access.

I don't know about Much about Mapic and DB2 /AS400. But I'm  Windows base
Visual Basic Programmer..

Please Help and Guid me how to do this task..


thanks


Best Regards
Krishan

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

www.viva-lancia.com
Best Regards,
                Lucas

If you can't convince them, confuse them.(Confucius)

L. Geheniau                                     M.I.S. supervisor /
Logistic Engineer
Tokheim Corp.
Industrieweg 5, 5531 AD Bladel                  The Netherlands
Fax: +31497381950
e-mail: geheniau@bladel.tokheim.com
        l.geheniau@chello.nl
sms: No phone!  0615026840