Hi steve
Thanks, Ok try your level best.
Kish
Hi Ste
>From: "Steve Levy" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: RE: DB2EUG: Data copy from Access to UDB database
>Date: Sat, 2 Jun 2001 13:10:58 -0400
>
>Kish,
>I have VB source which allows EXACTLY what you want. Powered by a Control
>table which specifies interval at which to transfer and last transferred
>date/time (which resides either on DB2 or in the source DB). Every time the
>app runs it checks Control Table and transfers all Source (access) data
>tables to DB2. The DB2 Table is refreshed and repopulated each transfer
>(optionally dropped and recreated to handle ever-changing schemas).
>Combined with the Windows Scheduler (which runs the windows app every day at
>midnight), the process is fully automated here. We, technically, sell the
>app as our data warehousing tool (so it's not my I.P. to "give"), but I'll
>see if I can get you code (in the name of professional courtesy) or a
>compiled version (in the name of Beta testing or something else free).
> --Steve
>
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of kishore lingamallu
>Sent: Saturday, June 02, 2001 11:51 AM
>To: [EMAIL PROTECTED]
>Subject: Re: DB2EUG: Data copy from Access to UDB database
>
>
>
>
>Hi Joson
>
>Thanks for your information.
>Please pass on more information.
>
>Kish
>
> >From: "Jason Hughes" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: [EMAIL PROTECTED]
> >Subject: Re: DB2EUG: Data copy from Access to UDB database
> >Date: Fri, 01 Jun 2001 13:58:13 -0400
> >
> >Kish,
> >One way (of the many) would be to create a form with some logic in Access
> >to export the desired data into fix width text files. You could then build
> >a script in UDB to load the exported text files into the corresponding UDB
> >tables. Each step would be a manual process but it would only be two
> >manual steps to kick off. I'm sure there is probably a way to automate it
> >even further depending upon your environment.
> >
> >I've built the Access form before but I think it was another one of those
> >items I lost in a tech support caused PC crash.
> >
> >Let me know if you decide to explore this route and I'll pass on what I
> >remember about how to do it.
> >
> >Jason
> >
> > >>> [EMAIL PROTECTED] 06/01/01 10:27AM >>>
> >Hi
> >
> >We have a situation where I need to copy the data from Access tables and
> >import them in to UDB tables every day.
> >
> >Do any body have suggestions for implementing solution for this kind of
> >situation.
> >
> >Thanks
> >Kish
> >
> >
> >_________________________________________________________________
> >Get your FREE download of MSN Explorer at http://explorer.msn.com
> >
> >
> >=====
> >To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> >For other info (and scripts), see
> >http://people.mn.mediaone.net/scottrmcleod
> >
> >
> >
> >=====
> >To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> >For other info (and scripts), see
> >http://people.mn.mediaone.net/scottrmcleod
> >
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>
>=====
>To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
>For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
>
>
>=====
>To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
>For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
>
Get your FREE download of MSN Explorer at
http://explorer.msn.com
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
