RE: Moving Access Data files up to Iseries

Hi Rich

As some others suggested there are some tools in SQL Server to help with
this even though they are not in MS Access. This is not as muich a problem
as it seems.

You could install a copy of SQL Server Express if you don't already have SQL
Server somewhere handy. There is an MS tool called the "SQL Server Migration
Tool for MS Access" which provides a wizard to migrate your existing access
tables into SQL Server including some error and exception reporting and also
data migration. You could then go through the process of migrating the
tables to SQL Server and use the SQL Server tools to create the appropriate
scripts. Given the number of tables this might well be worth the effort.
Trying it out is not that much work.

A wilder idea would be to write a perl script to create the SQL scripts for
you...

Regards
Evan Harris


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rich_Weislak@xxxxxxxxx
Sent: Thursday, 24 January 2008 8:41 a.m.
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.