Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to load Excel files into DB on Unix?

alexliznJan 7 2005 — edited Jan 7 2005

Hi folks,

Question>
======================================
Our source db is on HPUX, and we have Excel files transported onto the HPUX via FTP everyday, how can I load the Excel data into the source db with Heterogeneous Services on Unix?

I know that we can do these if the source db is on Windows as that way we can create the System DSN in Windows ODBC Administrator before we configurate HS listener/tnsname.

But in this case, it's on Unix! Is ODBC available on Unix? What shall i do?

Do you have any idea?

Thanks & Have a nice day everyone!
eilison
eilisonl@yahoo.com

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 4 2005

Added on Jan 7 2005

#data-warehousing, #warehouse-builder

2 comments

270 views