Data export using Microsoft Access

Hi,

I am using the Postgres ODBC driver (version 7.01.00.05) to export tables
from Access 2000 to PostgreSQL 7.0.2 on Linux. The problem is that all
tables and attributes that contain upper case letters are only accessible on
the new DB when enclosed in quotes, for example, a table called Test cannot
be accessed using "select * from Test where Val = 3", it has to be rewritten
as "select * from "Test" where "Val" = 3". It can be renamed using "alter
table "Test" rename to Test" but obviously if there is a fix or workaround
for this problem that would be better.

As there are no errors generated I have not attached the log files, as far
as both packages are concerned, everything is working fine.

Thanks,

Edward Thomas

--
CYNOSURE - Internet strategy and production

t: 01224 355271 | CYNOSURE
f: 01224 626227 | The Software Centre, Campus 2
e: ejt(at)cyno(dot)co(dot)uk | Aberdeen Science and Technology Park
w: www.cyno.co.uk | Aberdeen, AB22 8GU