Depending on how familiar you are with Access you can use the Query Builder to create append queries for the tables, if they are linked tables. Otherwise you can use VBA code to connect to the DB2 database and issue ODBC direct statements to load the data, this is the most efficient way. I used Access to move data from the OS/390 platform to DB2 UDB on NT. Otherwise you can have Access export the data into delimited fields so the data can imported by using DB2 Import command I believe.
Ron Draper
Computer Information Technology Specialist I
Missouri Department of Natural Resources
MIS Program
526-1077
[EMAIL PROTECTED]
Microsoft Certified Professional
| "kishore lingamallu" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 06/01/2001 11:27 AM
|
To: [EMAIL PROTECTED] cc: (bcc: Ronald Draper/MIS/DAS/MODNR) Subject: Re: DB2EUG: Data copy from Access to UDB database |
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
