Re: problem importing tab delimited text files

2011-01-16 Thread Ian McKnight
Thanks Richard I just included your handler in my test stack and it returned "can't open file(32)" - very useful indeed. I didn't think about sysError being used in that way - message to self - must spend more time reading the dictionary! :) On 15 January 2011 23:37, Richard Gaskin wrote: > I

Re: problem importing tab delimited text files

2011-01-15 Thread Richard Gaskin
Ian McKnight wrote: Thanks for the advice David. I went back and checked. As I still had the text file open in Excel when I was trying to import it into LC the file must have been locked in some way by Excel - as soon as I closed the file in XL it worked perfectly. Makes perfect sense really. I

Re: problem importing tab delimited text files

2011-01-15 Thread Ian McKnight
Thanks for the advice David. I went back and checked. As I still had the text file open in Excel when I was trying to import it into LC the file must have been locked in some way by Excel - as soon as I closed the file in XL it worked perfectly. Makes perfect sense really. I think I'll start writi

Re: problem importing tab delimited text files

2011-01-15 Thread David C.
On Sat, Jan 15, 2011 at 4:21 PM, Ian McKnight wrote: > Hi all > > I have a table of data in an excel spreadsheet.40 rows x 30 columns approx. > I save the file as a tab delimited text file for import into LC. > I import the file and its empty - nothing there in LC. > I open the text file in Notepa

problem importing tab delimited text files

2011-01-15 Thread Ian McKnight
Hi all I have a table of data in an excel spreadsheet.40 rows x 30 columns approx. I save the file as a tab delimited text file for import into LC. I import the file and its empty - nothing there in LC. I open the text file in Notepad and save it again, making no changes. I import the same file in