Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO Weirdness: Changes dots to #'s in FieldNames
All -
In inporting to Excel via ADO, I found fieldnames formatted as emails have their dots (.'s) changed to pound signs (#'s). I verified the fieldname correct as entered in the closed workbook. The change happens during the import. Is this to be expected? I'm an ADO rote user for now and couldn't even phrase the question right in 10 words or less for Google to find an answer. My workaround was to use J-Walk's closed workbook macro for the fieldname and ADO for the rest. Is there a way to do this in ADO without further hassle? Or is this just the way it is? Thanks in advance. ....best, Hash |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO Weirdness: Changes dots to #'s in FieldNames
One workaround would be to use the REPLACE function on the header row in your
code immediately after you execute the sql statement. (Replace all #s with dots) in the header row. " wrote: All - In inporting to Excel via ADO, I found fieldnames formatted as emails have their dots (.'s) changed to pound signs (#'s). I verified the fieldname correct as entered in the closed workbook. The change happens during the import. Is this to be expected? I'm an ADO rote user for now and couldn't even phrase the question right in 10 words or less for Google to find an answer. My workaround was to use J-Walk's closed workbook macro for the fieldname and ADO for the rest. Is there a way to do this in ADO without further hassle? Or is this just the way it is? Thanks in advance. ....best, Hash |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Leading dots...trailing dots | Excel Discussion (Misc queries) | |||
Match dBase with Fieldnames | Excel Worksheet Functions | |||
VBE Weirdness | Excel Programming | |||
Weirdness | Excel Programming | |||
VBA IDE Weirdness.... | Excel Programming |