ODBC import

[DKINGSTON]

In Access 2002 how do i import from an ODBC database to an
existing Access table?

 

[Putterer]

-----Original Message-----
In Access 2002 how do i import from an ODBC database to an
existing Access table?
.
Are you importing an ODBC table into Access or appending

it to an existing table?

 

[DKINGSTON]

-----Original Message-----

it to an existing table?
.
Append I guess. I am importing data from a table on an

AS/400 into an existing, but empty, Access table. If
appending will work I can always write a macro to empty
the existing table before appending. My problem is, when
I link the tables Access bogs down and eventually locks up
when i run large reports based on multiple queries, if i
import then i lose any relationships i've set up w/ the
imported tables. I'm stymied.

 

[Joe Fallon]

I used to connect to an AS/400 for Access reports.
Some tips:
1. Never open a linked table directly.
2. Always run queries.
3. Use an empty Access table to "download" data for a given date range (or
some other criteria) from the AS/400.
The idea is to take the "performance hit" once during the download. Then
base all reports on the local Access table.
e.g. Download the last full Accounting Month and then run 10 reports on that
data.