Help! - MS Access --> O7 Windows
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 CommandoReceived on Wed Jan 25 1995 - 01:59:20 CET