Re: Migrating MS Access DB to AS/400

Does MS Access allow you to export to a CSV file?  If so, then iSeries 
Access should allow you to transfer this CSV file to DB2.

We have an automated task which converts a MS Access database to a CSV and 
then executes an iSeries Access transfer.  To get the CSV creation to be 
automatic it took a little VB programming.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 





"Doug Hart" <doughart@xxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
06/11/2003 03:49 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     "Midrange Systems Technical Discussion" 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        Migrating MS Access DB to AS/400


I need to import a 250,000 record MS Access DB to a DB2/400 DDS'ed PF.
User wants to use standard Query to view the records.

Any suggestions?


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.