excel sheet load

ann · Post by **ann** » Sat Jul 30, 2005 6:53 am

hi all,
I have excel sheet to load in to a simple text file how to do that.

i have searched all the forums but i couldnt get any ans
thanku

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Sat Jul 30, 2005 11:57 am

You can use the 'save as csv' method.

chulett · Post by **chulett** » Sat Jul 30, 2005 12:24 pm

I did a quick search on excel odbc and got 37 matches, so your answers are out there. Like for example, this one.

Since you are on a Windows server you can read the .xls directly. Or you can always do the old standby of saving as a .csv first and then loading it via a Sequential File stage.

ray.wurlod · Post by **ray.wurlod** » Sat Jul 30, 2005 5:47 pm

The worksheet must be in columnar format with column headings. If it is not, the ODBC driver doesn't work, so you would need to revert to saving the worksheet in CSV or TXT format (the latter is tab-delimited) and processing that with a Sequential File stage.

trokosz · Post by **trokosz** » Mon Aug 01, 2005 9:37 pm

The answers you got are find but there is a IBI product called iWAY that can automate but it costs....the other recommendations have no cost....just FYI