[url="http://mails.datawatch.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=1;t=000300#000000"]This[/url] rather long sequence from a post about a year ago (time flies) seems to cover a similar problem, although the findings were apparently at variance!
It may provide some ideas to check out and it would be interesting to hear what results you get.
I can;t be sure it will provide you with what you are looking for though.
Trying to connect an excel file to my table. I am getting "source & table window columns must be of the same type". It reads the first 30 rows and at row 31 column 2 it errors out saying it cannot read data. The column has file numbers with a combination of numbers and characters. I formatted the column as text but it still reads the first file as a number. So the first 30 rows are numbers and the 31st one is a character file. Any ideas on what I can do.
[size="1"][ May 19, 2006, 01:43 PM: Message edited by: Todd Niemi ][/size]