Обсуждение: Exporting Microsoft Access tables to PostgreSQL

Поиск
Список
Период
Сортировка

Exporting Microsoft Access tables to PostgreSQL

От
"Markus Meyer"
Дата:
Hi folks,

how can I reliably export Microsoft Access tables to PostgreSQL? I tried
using the ODBC driver, but that doesn't keep all datatypes and doesn't
create indexes and stuff correctly. Also, I tried a VBA script I found on
the PostgreSQL website, but it has some bugs with creating indexes and
primary keys. Therefore the SQL code it creates only executes with errors.
Before I rewrite that thing I'm asking you, if you have a quicker/better
solution.

Thanks in advance.

Regards,


Markus