My integer types migrated from Access one level lower than is shown in the Map in the wizard. Thus, integer became int2 instead int4
Also, long integer became int4 instead int8, although long integer wasn't in the map so that probably doesn't count formally. At the same time, byte became int2, but apparently that is the only possible way because I'm not seeing an 8-bit integer type in postgres (please let me know if there is one). P.S. I'd like to suggest enhancements for pgAdmin3: 1) getting integer to map into int4 2) adding a source type 'long integer' with a mapping to int8. In the long run, it would also be nice to have an 8-bit integer type if there isn't one yet. Sincerely, r. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly