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
In our medical software we have a product called ChartGallery that is basically a document imaging product that allows all extraneous documents and files to be associated with a patient's record. This includes Excel documents. StrataFrame does not have a mechanism to parse the Excel document, but you can create a Binary (blob) field in your database and save the entire Excel document into that field.
This is what we do. We save the Excel document into the blob field and then when the end-user wants to edit the record, we create a temp file from the stored byte array and launch excel by calling the following:
System.Diagnostics.Process.Start("MyExcelFile.xls")
If this is not the approach you are looking for, you could convert the documents from Excel to Access and then build a SF business object to talk to the Access database and move them over to your Oracle database through your other business objects. There are a number of options here.
Hope this helps.