Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORACLE & Excel

Re: ORACLE & Excel

From: <davide_at_yahoo.com>
Date: 16 Apr 2002 09:17:49 GMT
Message-ID: <a9gq7t$31pru$3@ID-18487.news.dfncis.de> 





s Lehaire <s.lehaire_at_meilleuregestion.com> wrote:


> I've got a datafile in excel and I want to import this file in my Oracle DB.

> How can I connect to the ODBC under excel (in VBA) to import my worksheet?




Save the file as a comma-delimited one and then use SQL*Loader to
load it into your Oracle database. See the documentation about SQL Loader.



Davide
Received on Tue Apr 16 2002 - 04:17:49 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US