Hi,
I'm having to pull data from some other worksheets, and am using an ADO
Connection, and select statement to get the details from the ranges.
The problem is that some of the columns have odd column names, which are
causing problems.
One has columns such as "01/04/2005", 01/05/2005" etc. The sql here doesn't
bring back the columns but the result of the math calculation of 1 divided by
4 divided by 2005. Does anyone have any ideas on this? I've tried placing
square brackets round the column names to no avail.
The other sheet has column names with spaces in, such as 'Opening Balance'.
Again I'm having problems with these.

If anyone has any ideas/workarounds for the above (I can't change the column
names as they are not under my control) it would be most appreciated.

Many thanks in advance.
Andy