Could you post what you are doing in Access? Are you just copy/pasting
from a local table to a linked odbc table? Or are you executing insert
statements in a VBA for loop, if so please post the VBA code?
There are some settings in the ODBC driver that can effect performance,
but the types of SQL statements you are executing often have a much
greater effect on overall performance.
Also if you could turn on the logging in the ODBC driver, often Access
is executing queries on your behalf that you may be unaware of it.
Zlatko Matic wrote:
> Hello,
>
> I use MS Access for data import. Access imports csv file, make some
> calculation and transffers data to PostgreSQL.
> Unfortunately, it takes a lot of time to transfer data to PostgreSQL.
> My odbc settings are following:
>
>
--
David Gardner