Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news-FFM2.ecrc.net!newsfeed.vmunix.org!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.alt.net!plato.usenetgateway.com!not-for-mail From: AS.Arockiasamy Newsgroups: comp.databases.oracle.tools Subject: Re: 'Save as' operation using winapi in oracle forms Date: Tue, 09 Sep 2003 03:38:38 -0400 Organization: dBforums Lines: 62 Sender: AS.Arockiasamy Message-ID: <3346592.1063093118@dbforums.com> References: <3037289.1056461734@dbforums.com> User-Agent: dBforums X-Original-NNTP-Posting-Host: db1.hotscripts.net X-Original-Trace: 9 Sep 2003 08:02:23 GMT, db1.hotscripts.net X-Authenticated-User: usenetgateway Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:82887 Tks Mani, for the reply.. And here i will explain my requirements... I need to import data from XLS to SQL server.... But due to the XLS BUG, i can't import fully (One of my col. contains both str, and numeric value... it takes only first col, value if that is str, then rest of the numeric value is Shown my table as NULL and vice versa...)... To overcome this , i need to save my xls file to TXT with TAB delimiter(This process i am doing currently mannually, and WANT toAutomate this process thro' some script).... All my above is Running in DTS.... Now can i incorporate this SAVEAS mehtod in my DTS to automate ...? Thats my question....? i don't want to open xls file and do the changes...... if my dts runs, its automatically, save the file to txt with TAB delimiter. and run the following DTS process.... Appreciate if you can help...?? Thanks in Advance.... AS -- Posted via http://dbforums.com