-
Exporting data from Excel to Oracle
Hi Everyone,
Can anybody help me getting an exe or code with which I can Export
data from excel to oracle database.
Sunny
-
Re: Exporting data from Excel to Oracle
Do you have MS Access? Bringing it into MS access converts it to a "real"
table with a stucture. Set up a ODBC Driver then export the data in Access
to Oracle using the ODBC driver and the access export function.
Steve
"sunny" <sun@hotmail.com> wrote:
>
>Hi Everyone,
> Can anybody help me getting an exe or code with which I can Export
>data from excel to oracle database.
>
>Sunny
-
Re: Exporting data from Excel to Oracle
"sunny" <sun@hotmail.com> wrote:
>
>Hi Everyone,
> Can anybody help me getting an exe or code with which I can Export
>data from excel to oracle database.
>
>Sunny
-
Re: Exporting data from Excel to Oracle
"sunny" <sun@hotmail.com> wrote:
>
>Hi Everyone,
> Can anybody help me getting an exe or code with which I can Export
>data from excel to oracle database.
>
>Sunny
Save the file as a .csv file and use sqlldr to import the data
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Bookmarks