RE: Migrating MS Access DB to AS/400

In access there is a export option, and you can give it the as/400 ODBC
connection... I used this last year, and it worked pretty well...

tim

> -----Original Message-----
> From: doc6502 [SMTP:doc6502@xxxxxxxxx]
> Sent: Wednesday, June 11, 2003 3:14 PM
> To:   'Midrange Systems Technical Discussion'
> Subject:      RE: Migrating MS Access DB to AS/400 
> 
> Doug
> 
> I think you can save the file as a CSV file, upload it to the IFS on the
> AS/400, and then copy the file to a pre-defined DB2/400 file using
> CPYFRMIMPF (Copy From Import File).  I've used this method to convert
> Excel
> spreadsheet data to DB2/400 UDB files.  You may have to play around with
> the
> settings on the CPYFRMIMPF command, but you can manage it.
> 
> -Doc
> 
> > -----Original Message-----
> > From: Doug Hart [mailto:doughart@xxxxxxxxxxxx] 
> > Sent: Wednesday, June 11, 2003 3:49 PM
> > To: Midrange Systems Technical Discussion
> > 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.
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or 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 the message.