HomeForum
Welcome, Guest

RE: ETL Process to load excel data in to Oracle Table
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: RE: ETL Process to load excel data in to Oracle Table

RE: ETL Process to load excel data in to Oracle Table 5 years, 2 months ago #430

  • simon wickham195
Hi,

I have created a table in my Oracle DB to allow me to load data from an excel spreadsheet to this column call cost.

I have created an import and mapped the required field called cost to F4 with my target being the Oracle DB and the Source being excel.

When I try to run Visual Importer I get the following :

Information 14/03/2007 18:42:20 Source File(s): E:\Intranet Migration\Export XLS\Updated Cost.xls
Information 14/03/2007 18:42:23 Processed: 0 Records
Information 14/03/2007 18:42:23 Errors: 32
Information 14/03/2007 18:42:23 Records per second: 258.06
Information 14/03/2007 18:42:23 Execution of Import Script: COST completed
Information 14/03/2007 18:42:23 Package Finished

Can you please tell me where I am going wrong.

Thanks

RE: RE: ETL Process to load excel data in to Oracle Table 5 years, 2 months ago #431

  • Mike81
Hi.

Can you email use a screnshot of your import, excel file and table creation script please

Mike
  • Page:
  • 1
Time to create page: 0.14 seconds

Testimonials

Support team is quick and very often they reply to forum posts within minutes.

Mark Jonson,
EDS

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top