Re: Create Table from Excel-Data

From: Jack <ocpdba_at_texas.ne>
Date: Fri, 19 Mar 1999 21:37:22 -0600
Message-ID: <UJEI2.51280$YV6.31946_at_news2.giganews.com>


Here it is, quick and dirty.

Create the table in Oracle.
Open Access.
Link Oracle table.
Import Excel datafile.
Open imported Excel data table, copy all rows, open linked Oracle table, paste. Works great.

Jack Silvey
Oracle Certified Professional

a922777 wrote in message ...
>Can somebody tell me a quick way to create a table in Oracle based on
>data which is in Excel? Thanks. Erich Vontobel Switzerland
>--
>Posted via Talkway - http://www.talkway.com
>Surf Usenet at home, on the road, and by email -- always at Talkway.
>
Received on Sat Mar 20 1999 - 04:37:22 CET

Original text of this message