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
