Running MS Query returns results formatted as text

Dick Kusleika <dkusleika.DeleteThis@gmail.com> wrote in
microsoft.public.excel.querydao:

> I've asked some other people to look at and I'll report back when I
> hear something.

Glad you have been able to reproduce this and thanks very much for your
efforts, sorry that I've not replied for a while been on holiday.

My only comments is that from observations here it does depend on the
amount of time the Excel spreadsheet has been opened.

Since telling the end users here to close it when they are not using it
plus also removing the option for 'enable background refresh' in Excel |
Data | Import External Data | Data range properties (and having all the
options for 'Data range control unticked/unchecked) there have been no
more occurrances - although as you've notice there is a 'random' element
to it.

Don't you love computers!

Cheers again,

- MDW.