Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [URGENT] Access Table into Oracle
If you are going to do this a lot, change the field names ( and the table name) in Access to all upper case ( if you cannot do this, make a copy of the table with Upper case attributes before exporting to Oracle ( or export the data as a CSV file and load into a pre-created Oracle table using SqlLdr). .It will same you much grief in using it if you can avoid the need for the quotes - ...
Philippe Michel <nospam_at_nospam.com> wrote:
>Hello,
>
>I have imported an MS-Access Table into an Oracle dbs. An I will have to
>do this some times in the futur.
>
>The field names are in lower cases under Oracle ( the Table name too,
>but I can easylly correct this). How can I write an SQL command with
>lower case field names ?
>
>many thanks for any help,
-----------== Posted via Newsfeeds.Com - Uncensored Usenet News ==----------
http://www.newsfeeds.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Ulimited Fast Downloads - 19 Servers =----- Received on Mon Apr 29 2002 - 09:52:13 CDT