import from as/400 to existing table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dkingston - 03 Dec 2003 18:53 GMT

i am using access 2002 to import data from various an
as/400. when i use file,get external data,import and then
use ODBC databases, machine data source access creates a
new table. how can i get access to import the data to a
table that already exists?
please reply via post or to:
d k i n g s t o n (at) j a g l y n n (dot) c o m

Reply to this Message

Joe Fallon - 04 Dec 2003 01:47 GMT

Don't click Import.
Click Link.
Then write a query off the linked table to extract only the records you need
and Append them to your existing table.

Signature

Joe Fallon
Access MVP

> i am using access 2002 to import data from various an
> as/400. when i use file,get external data,import and then
[quoted text clipped - 3 lines]
> please reply via post or to:
> d k i n g s t o n (at) j a g l y n n (dot) c o m

Reply to this Message