add Excel data to Oracle - Xtreme Visual Basic Talk

11-11-2003, 10:01 AM

younjjun

Newcomer

Join Date: Nov 2003

Posts: 4

add Excel data to Oracle

How do I add excel data to an Oracle Database?
Is there a simple procedure?

Thanks!!
Alexa

11-11-2003, 12:41 PM

Shurik12

Steppe Walker

Retired Moderator
* Expert *

Join Date: Jul 2002

Location: Ukraine/Russia/Belgium

Posts: 7,227

Hi,

Here is 'zero-programming' solution.
If you have Access installed, link the Excel spreadsheet to it and the table from Oracle. Then build an append query.

Rgerads,
Shurik.

11-11-2003, 03:02 PM

younjjun

Newcomer

Join Date: Nov 2003

Posts: 4

Quote:
Originally Posted by Shurik12
Hi,

Here is 'zero-programming' solution.
If you have Access installed, link the Excel spreadsheet to it and the table from Oracle. Then build an append query.

Rgerads,
Shurik.

Wow... that was easy. Thanks for your help Shurik!!

-Alexa

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Posting Large amount of data into Excel	Kevin	Excel	9	09-03-2003 07:29 AM
Get data from Excel and match with SQL data	poli13	Excel	6	08-21-2003 04:02 PM
Populating an Excel Worksheet embedded in an Access Report with data	mavalon	Word, PowerPoint, Outlook, and Other Office Products	7	04-23-2003 01:31 PM
Excel Data Into Oracle	sachin	Database and Reporting	6	07-27-2002 10:13 AM
Oracle Date in Excel	tstbuddy	Word, PowerPoint, Outlook, and Other Office Products	10	06-11-2002 08:10 AM