I am guessing Access can export SQL DDL for the table structures(I think I
did that once). It can also (probably) export SQL DDL for all of the
INSERT's necessary to populate the tables on the iSeries.
Open up iSeries Navigator, go to the machine you want to load it on, and
click on the database icon in the left nav. At this point you should see an
icon in the lower right pane that denotes the SQL editor. Opening that will
allow you to execute SQL scripts.
HTH,
Aaron Bartell
http://mowyourlawn.com
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rich_Weislak@xxxxxxxxx
Sent: Wednesday, January 23, 2008 1:41 PM
To: Midrange Systems Technical Discussion
Subject: Moving Access Data files up to Iseries
All, I have over 150 2003 access database files that I need to copy up to
our Iseries system, in the past I would print screen the file layout of
the database and create the same database on the Iseries, but this time as
you can see I have a lot more to do, does anybody have a easy way of
copying these database up. Any suggestion will be helpful.
CONFIDENTIALITY NOTICE: This message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information. Any unauthorized review, use, disclosure or
distribution
is prohibited. If you are not the intended recipient, please contact the
sender by reply e-mail and destroy all copies of the original message.
midrange.com
