Using Strataframe to load data in Excel files into Oracle


Author
Message
Kari Paukku
Kari Paukku
StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)
Group: Forum Members
Posts: 65, Visits: 820

Hi,

could I use SF to load data that exists in Excel-files into a Oracle database? The task would be to load data from approx. 500-1000 files. All the files have the same layout but different name and different number of records in them.

The work is done by a human - one file at a time - and the data needs to be linked into existing data already in the Oracle database. This linking is done by first selecting e.g. the company to which the data in the excel-file belongs. Additional functionality could be e.g. to load the Excel-file as binary object into the database.

What do you think, could SF be used for this kind of work...

TIA,

Kari


GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search