Skip site navigation (1) Skip section navigation (2)

FW: Data export using Microsoft Access

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: FW: Data export using Microsoft Access
Date: 2001-07-18 08:09:32
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F74618@MAIL_EXCHANGE (view raw or flat)
Thread:
Lists: pgsql-odbc
oops, screwed up the mailing list address
> -----Original Message-----
> From:	Henshall, Stuart - WCP 
> Sent:	Wednesday, July 18, 2001 9:06 AM
> To:	'ejt(at)cyno(dot)co(dot)uk'
> Cc:	'psql-odbc(at)postgresql(dot)org'
> Subject:	RE: Data export using Microsoft Access
> 
> Hello,
> 	If you use "<TableName>" then PostgreSQL is case sensitive. If you
> use <TableName> it rounds it down to lower case. One way I've used for
> converting tables from pg to access is to have a pg friendly tabel
> definition (all names lower case, no spaces or punctution bar _) and then
> have Access Queries (similar to PostgreSQL views) acting in place of the
> old
> tables, using AS to convert field names eg:
> SELECT field_pg AS [ANAccess / field] FROM table_pg
> (NB. try to avoid using pg at the start of PostgreSQL tables, used for
> system tables).
> hopt this helps,
> - Stuart
> (Sorry if this is wrongly addressed as the mail digest sometimes contains
> character sets my Outlook doesn't recognise and therefore just gives me
> one
> big text file)
> 
> ORIGINAL MESSAGE:
> 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

pgsql-odbc by date

Next:From: Henshall, Stuart - WCPDate: 2001-07-18 08:37:08
Subject: RE: Access 97, Error - Data changed by another user, Copy to Clipboard or Drop changes
Previous:From: JosephDate: 2001-07-17 17:58:18
Subject: Access 97, Error - Data changed by another user, Copy to Clipboard or Drop changes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group