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
