Please let me know the method of loading an xls doc in DS.Can it be treated as sequential file stage, then with what delimiter.
Or it requires a DSN to be created,in that case which stage to use.
Thanks
Loading excel files
Moderators: chulett, rschirm, roy
As far as I am aware, and in line with what I've done in the past, you'll need to save the spreadsheet as csv format and import using a sequential file stage.
Be careful that the correct number of columns get exported and that the data itslef doesn't contain commas!
Because of these gotchas, I have written a bespoke macro to ensure the correct columns are exported and with the correct format etc.
Be careful that the correct number of columns get exported and that the data itslef doesn't contain commas!
Because of these gotchas, I have written a bespoke macro to ensure the correct columns are exported and with the correct format etc.
You cannot link directly to ODBC on UNIX without {buying and} installing 3rd parts software.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Try googling 'excel unix' there are plenty of people trying to do the same thing, and possibly have solutions.
Try this link for starters... http://www.ibm.com/developerworks/linux ... /l-pexcel/
Try this link for starters... http://www.ibm.com/developerworks/linux ... /l-pexcel/
Re: Loading excel files
There are some non-free unix odbc drivers for Excel available.
For example - http://www.easysoft.com/products/data_a ... index.html
If converting to csv becomes acceptable, maybe your admin can install this utility for you in case your OS doesnt already have it.
http://www.linuxmanpages.com/man1/xls2csv.1.php
As Oddjob mentioned there may be other alternatives that you can find using google.
For example - http://www.easysoft.com/products/data_a ... index.html
If converting to csv becomes acceptable, maybe your admin can install this utility for you in case your OS doesnt already have it.
http://www.linuxmanpages.com/man1/xls2csv.1.php
As Oddjob mentioned there may be other alternatives that you can find using google.