Convert "xls" file to "txt" file

Hi, I hope someone can help.

I need to convert an Excel spreadsheet to an ASCI text file, in order to 
import data into a datawindow. I want to try and avoid asking users to save 
their files as text files and there are issues surrounding the use of ODBC 
to link to Excel.

I am currently able to view my Excel data by way of an OLE object but if I 
try "Getdata", only the first 72 rows are imported to a string or blob and 
then subsequently to the datawindow.

So I am looking for an OLE function which will "save as" my file.

Help would be greatly appeciated.

7/31/2001 12:58:15 PM
sybase.ase.general 8655 articles. 0 followers. Follow

0 Replies

Similar Articles

[PageSpeed] 35


Similar Artilces:

"File" to "File$date"
Okay... Thanks for all your answers! From all, I combinded the perfext solution: rename("test.txt", "test" . &heute() . ".txt"); sub heute { return (localtime(time))[3] . (localtime(time))[4] . = ((localtime(time))[5] 1900); } Thanks ;) Andreas -----Urspr=FCngliche Nachricht----- Von: Sudarshan Raghavan []=20 Gesendet: Samstag, 14. September 2002 15:21 An: Perl beginners Betreff: Re: AW: Rename "File" to "File$date" On Sat, 14 Sep 2002, Sudarshan Raghavan wrote: >=20 > #!/...

Rename "File" to "File$date"
Hy everybody in the List! I have a Problem writing a little perl application... Im a very newbie to programming and need your help :) The Problem is: I have a file "dev.txt" and I want to rename it once a day (with a = cronjob) like "dev13092002.txt" So i need to rename it with a date variable. All I have at the moment is: #!/usr/bin/perl $d =3D `date`; $d =3D /pattern1(pattern2)/; sytem("cp test.txt test`$d`.txt"); Does anyone of you know how to do that? THANKS in advance! =09 | Telematikzentrum D=FCrrwangen GmbH &am...

Convert file on a path to "Stream" without the use of html "file" control
Hello, Basically I am building a CMS of sorts, I have built in the functionality to generate a thumbnail of an image that get's catalogued, I then take my original file and transfer it to the server along with the thumbnail - which is all working fine... Using the html file control accpets the following: (name - "fileImage") Dim x As Stream = fileImage.PostedFile.InputStream() Which is fine - one file at a time, however I need to build in the functionality to get all the image files from a directory and batch transfer them. basically I will have the path similar to:...

Precedence of "where" ("of", "is", "will")?
Nobody on #perl6 today could answer this one. Is: Str | Int where { $_ } the same as: (Str | Int) where { $_ } or: Str | (Int where { $_ }) ? Followup questions, Mr. President: What kind of operators are "where", "of", "is", and "will"? Is there a reason that S03 doesn't list them? What are their precedence(s)? -- Chip Salzenberg - a.k.a. - <> Open Source is not an excuse to write fun code then leave the actual work to others. Chip Salzenberg writes: &...

.ALLCOL("%COLUMN%", " ", ", ", ", ")
Do you know anyway for me to exclude a subset of columns returned by this function. We have two columns (rec_user and rec_datetime) which are in all of our tables, but when generating triggers I want automatically generate a script which does not include those two columns but does include all other columns in that table. Bruce I should add that I am using PD Bruce "Bruce Lamb" <> wrote in message > Do you know anyway for me to exclude a subset of columns returned by this > function. ...

Visual Studio 2005. "Quick Find", "Quick Replace", "Find in Files", "Replace in Files" functionality no longer works
Hello, I just run into problem that find functionality is no longer working in Visual Studio 2005. "Quick Find", "Quick Replace", "Find in Files", "Replace in Files" functionality no longer responds. These are necessary functions when build any website. Any solutions on how to fix this problem?Improving lifestyles for luxury pets: TheFabulousPet In Menu bar click Window -> Reset Window Layout. It solves the problem.Improving lifestyles for luxury pets: TheFabulousPet...

Shortcut Key for "File" -> "Save As File"
Hi all, We can save as DataWindow Object into .XML file through "File-> Save As File" option (after opening DataWindow Object in PB). Here I am unable to identify shortcut key for "Save As File", can any one tell me the shortcut key is available or not? if yes, could you please tell me the shortcut key for "Save As File" menu item. Advanced thanks for your help. -Siva On Feb 4, 7:45=A0pm, Siva Prasad <> wrote: > Hi all, > > We can save as DataWindow Object into .XML file through "File-> Save > As...

quotes, quotes, quotes...
I am getting this error and I know what is causing it, but I have no idea how to fix it, any help would be great. The script steps through the /var/log/messages file on a linux server and puts The entries into a mysql database. However when it gets to the 'hlt' line in the messages file it just barfs. The single quotes are freaking it out. I know about quotes but not how to use in this situation. Thanks, Paul Error: May 27 17:53:00 localhost kernel: Checking 'hlt' instruction... OK. <----- doesn't like this in the messages file DBD::mysql::st exec...

File write error on file "acct" in module "GWEACCT".
--____HHJZYVOOFXDLYDIWHUSF____ Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 Content-Disposition: inline; modification-date="Tue, 24 Sep 2007 10:15:42 -0400" VGhlIG1vcm5pbmcgb2YgV2VkLiBTZXB0IDE5dGguIHdlIHN3aXRjaGVkIG91ciBHV0lBIG92ZXIg dG8gdmVyc2lvbiBHVzYuNSBTUDYgZnJvbSB2ZXJzaW9uIEdXNS41LiAgVGhlIG5leHQgbW9ybmlu ZyB3ZSBzdGFydGVkIGdldHRpbmcgdGhlIGZvbGxvd2luZyBlcnJvciBpbiBvdXIgR1dJQSBsb2cg ZmlsZTsNCg0KMDktMjAtMDcgMDg6MjI6MTAgMCBVbmtub3duLCBlcnJvciBjb2RlID0gODIxMA0K MDktMjAtMDcgMDg6MjI6MjEgMCBNU0cgNDAwIERlZmVycmVkIGRlbGl2ZXJ5IGZpbGUgbWVtb3J5 IGVy...

Hello I moved my application from IIS6 to IIS7 on windows server 2008.   And now, when a user try to download, from my web application , a file with a filename that contains the "+" sign, I get the "404 - File or directory not found." error message.For example "20-requirement+result.doc" would generate an error.It uses to work fine on windows server 2003 with IIS6.thanks in advance for your help Look in the IIS config file Its located in the System32 Directory - ex.   C:\Windows\system32\inetsrv\config\applicationHost.config L...

File write error on file "acct" in module "GWEACCT"
Getting this on GWIA 6.02 scrolling across the screen. Runs on a Win2ksp3 box. Searching TID's...... JG I'd probably whack most of the subdirs under gwia and let gwia rebuild. -- Michael J. Bell Novell Support Connection Volunteer Sysop Author of Guinevere ( PLEASE: Do not e-mail me privately unless specifically asked. I'm a volunteer, not a Novell employee! All opinions and advice provided are MINE alone and NOT Novell's unless specifically identified as such. Novell does not officially monitor these forums. Enhance...

Is there a way to write Atlas "text/xml-script" script Into single file like ".js" or ".css" file
I have tried the following code: <script type="text/xml-script" src="Default.aspx.ajax"><script type="text/xml-script" src="Default.aspx.js"><script type="text/xml-script" src="Default.xml"> but they dit dot work. thanks.msn & I believe it does not work as the XML-Script processor takes the content within the script tags to do processing and ignores the src tag. I think this will be a nice feature to add in the next release....

Convert "BCC" to "To:"
I'm guessing the answer to this is no, but I thought I'd ask. Is there any way to set GWIA to convert a "BCC:" recipient to a "To:" recipient? (Each person would be it's own To: Address) The problem we are having is that we use BCC because we don't want people to see other customers email addresses. We have found that some Spam software is tagging the e-mail as spam because the customers name is not in the "To:" field. Your thoughts or comments would be appreciated. --Matt No there isn't. Nor should there be because the recipien...

"Link-", "Libs-" and "Import-" -entries in CB2010-project file
Hi. Could anyone explain to me, what the meaning of the different "link/lib/import"-entries in the project-file is? I'm confused. Using the GUI there is only the "Runtime package"-list - the reason and function for that one, I do understand. But what do the others? And which one *is* the "Runtime package"-list?? <LinkPackageStatics></LinkPackageStatics> <LinkPackageImports></LinkPackageImports> <PackageImports></PackageImports> <AllPackageLibs></AllPackageLibs> Thanks a lot! Best Regards Eike Pete...

Web resources about - Convert "xls" file to "txt" file - sybase.ase.general

Resources last updated: 1/20/2016 1:39:12 AM