import from excel to oracle

[levogiro]

hi,

i'd like to know if someone knows how to import data from an excel datasheet to oracle.

thanks.

 

[Dooda]

Assuming you are a Delphi developer, a longish way round but very flexible would be to use xlsrw, which allows excel access from Delphi, and your usual access to Oracle. (I don't immediately recall the address for xlsrw but if you cannot find it on the web, say so and I'll dig it out.)

 

[levogiro]

Dooda,

i looked over the internet but couldn't find the component you've mentioned, so if you could send it to my e-mail it would be great.

benedito.almeida@confignet.com.br

thanks.

 

[Dooda]

Sorry, I should not have abbreviated the name, which is XLSReadWrite. It's available from

http://www.axolot.com.

I notice that they have a version II now available; I've only used the original which I found fast an accurate once I'd got into it. To read a spreadsheet, you call a read function which invokes functions for each cell type you are expecting (number, string, boolean). This seemed odd but does avoid using variants and then working out what you've got.

 

[levogiro]

dooda,

thanks for your help, but we are not allowed to use third party components. i'll have to do it with delphi components. do you know where i can find this kind of algorithm ?

thanks again.

 

[Dooda]

The only other thing I know of is the Excel file format and stuff like a VB class etc at

http://www.wotsit.org