(Tested)Data type matching:
-----------------------------------------------
| ACCESS | POSTGRESQL |
-----------------------------------------------
| Text | Varchar(255) |
| Memo | Varchar(65535) |
| Number: Integer | Int 2 |
| Long Integer | Int 4 |
| Single | Float 4 |
| Double | Float 8 |
| Date/Time | TimeStamp |
| AutoNumber: Long | Serial |
| Yes/No (Boolean) | Int 2 |
| OLE Object | ByteA |
-----------------------------------------------
ODBC Driver Settings:
--------
|Page 1|
--------
- Check "Disable generic optimizer"
- Check "KSQO..."
- Check "Recognize unique indexes"
- Set "Unknown sizes" to "Maximum"
- Check "Text as LongVarChar"
- Set "Max Varchar" to 255
--------
|Page 2|
--------
- Check "LF <-> CR/LF conversion"
- Check "bytea as LO"
- Check "True is -1"
- Set "Int8 As" to "double"
Make sure you use the ANSI driver
Hope it helps.
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.3/359 - Release Date: 08.06.2006