ODBC import

  • Thread starter Thread starter DKINGSTON
  • Start date Start date
-----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
Click to expand...
it to an existing table?
 
-----Original Message-----

it to an existing table?
.
Append I guess. I am importing data from a table on an
Click to expand...
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.
 
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.
 
Back
Top