Problems Opening an EXCEL text file

Ian McKnight iangmcknight at gmail.com
Fri Jan 7 05:46:33 EST 2011


Hi

I have a table of data held in a table in EXCEL and I want to import it into
a field in a LC stack.
I saved the file from EXECL as a tab delimited text file
and used the following handler

*

on* mouseUp

*answer* file "choose" with *type* "text|txt|TXT"

*if* it is empty or it is *cancel* *then* *exit* mouseup

*put* "file:"&it into fName

*put* URL fName into fld "display"
*

end* mouseUp
The stange thing is that this doesnt appear to work - I get a blank field.
However if I open and save the text file in NotePad or WordPad and then run
the handler I get the data displayed in the field correctly.

So how do I get the text file to be recognised without putting it through
Notepad? What does EXCEL do to the file that NotePad doesn't? I'm using LC
4.5.1 and have also tested this on Rev Enterprise 4.0 both on Windows (Win 7
and XP)

-- 
Regards


Ian McKnight

iangmcknight at gmail.com
=======================



More information about the Use-livecode mailing list