| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range with odd column names causing problems
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| my personal.xls file is causing problems | Excel Discussion (Misc queries) | |||
| Named range causing really weird problems - HELP | Excel Discussion (Misc queries) | |||
| Rand () causing Problems. | Excel Discussion (Misc queries) | |||
| Range("rng").calculate causing problems? | Excel Programming | |||
| Range("rng").calculate causing problems? | Excel Programming | |||
Threaded Mode
