Help! - MS Access --> O7 Windows

From: Douglas Hackney <hackneyd_at_ix.netcom.com>
Date: 25 Jan 1995 00:59:20 GMT
Message-ID: <3g47p8$ck4_at_ixnews1.ix.netcom.com>


Problem: In exporting data from MS Access 2.0 to Oracle 7 for Windows (O7W) column names are being surrounded with "

Background: I'm building a sales laptop system using O7W. The data is currently in a MS Access 2.0 database. The MS Access 2.0 Export:SQL Database:Oracle7 process works without a hitch, except that the column names are being preceded and followed with ". The " characters are not appearing when I query the system tables to show the column names, I discovered them by looking at the SQL string from a successful Browser test query.

Using SQL Plus O7W reports "invalid column name" if I don't include the  " (select smdemo.branch."city" from smdemo.branch), browser is seeing the " when it loads the schema, another query tool (Andyne GQL) is not seeing the " when it downloads the schema.

Timeline: This system is due by the end of the week (typical bleeding edge development cycle).

Questions:
1. is it possible to export from MS Access 2.0 to O7W without getting the " around the column names?
2. is it possible to edit the column names in O7W to remove the "? 3. is it possible to do a global search & replace on the column names in O7W to get rid of the "?

Any assistance would be appreciated.

-- 
-----------------------------------------------------------------------
Doug Hackney                                Hackney-D_at_clavin.med.ge.com
'94 RF900R      '93 DR350S      '87 GSX-R11     '72 Norton 750 Commando
Received on Wed Jan 25 1995 - 01:59:20 CET

Original text of this message