Access and AS400

G

Guest

Hi
I would like to get some input on how to directly send
data from Access into As400. What I'm trying to do is
after a user is done with creating case in Access to then
click a button and upload case into As400. He would be
always adding to a table in AS400. I would think this is
possible, I'm just looking for the best(or any for that
matter) solution.
Thank you.
 
E

Ed

Probably the simplest approach is to link to the AS/400 table and then do an
append query to add your data to the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC link to AS400 in Access 2007 2
Beginner: How do I link via ODBC from a PC into an AS400? 7
Exporting Access Tables to AS400 1
AS400 5
Linking to AS400 from Access 2000 1
Data Access Layer (DAL) Design - Help please 3
Date conversion for AS400 1
RPG (AS400) to .Net migration 1

Top