Re: Help Me

[Lucas Geheniau <geheniau@xxxxxxxxxxxxxxxxxx>]

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