The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 |
Newsgroups: comp.databases.oracle.misc
From: joel garry <joel-ga...@home.com>
Date: Fri, 05 Oct 2007 16:17:19 -0700
Local: Fri, Oct 5 2007 7:17 pm
Subject: Re: excel to oracle
On Oct 5, 7:37 am, "Tim B" <nos...@someisp.ca> wrote:
> I have some data in an Excel spreadsheet - about 100 -200 records - that I Last week someone suggested Apex, so I gave it a try. It was real > need to import into Oracle, likely with some transformation required. I can > convert it to csv or xml via MS Access and then set it up as an external > table and proceed from there. What other ways could you suggest that might > be feasible for this task? Is there another way to do it with xml as the > source? easy (I mean including downloading XE, installing, creating a wizard and cut-and-pasting a spreadsheet into it), but it screwed up on special characters like copyright. I normally use awk in korn shell scripts to masticate and load csv's jg You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||