>
> Hello,
> 	I am new to working on Excel 7.0 as a programming tool. Could any one
>  please help me with this query ?
>  I would like to know if  there is any way I could export data from Excel
>  to Oracle i.e., convert tables in excel
> to tables in Oracle using  VBA.
>
> Regards,
> Pratibha
> Pratibha.Sundarmurthy@pcm.bosch.de


Hi Pratibha,

I think I have already developed the tool you need. My tool, oraxcel, is
an addin for Excel and it lets you use Excel as a front-end to Oracle.
You can fetch values directly into a spreadsheet or prepare an insert
statement in a sheet and submit it to Oracle.

Please have a look at some screen prints or download the lite version for
free:

http://members.aol.com/gjlinker/projects/oraxcel

You could record a macro which drives the full version of my tool as a
solution to your problem.

Kind regards,

Gerrit-Jan Linker