Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
querying a spreadsheet with formatted cells using ado
I have an excel macro that I use ADO to pull in the contents of another
spreadsheet. In the past I have had plenty of success without too many problems on extracting data from another spreadsheet, however today I ran into a problem and I was hoping someone would be able to help. I have one particular column in my spreadsheet that is causing me a lot of problems, the spreadsheet was supplied by a client and the column in question contains zip codes. The zip codes can be of the US or Canada and they have special format on this column for zip codes. When I run the query on it, the fields with Canadian zip code don't get pulled in. Any ideas as to why this is the case. -- J. Daly |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
querying a spreadsheet with formatted cells using ado
J.D.,
Just a suggestion.... I see from a quick Google that Canadian post codes can be something like "A1A 1A1", which is St John's in Newfoundland and Labrador, apparently. Does ADO think this is a number in hex, convert it, then come to postcode that cannot be convert/invalid hex and consequently not import the whole column because it can't detect the data type. NickHK "J.D." wrote in message ... I have an excel macro that I use ADO to pull in the contents of another spreadsheet. In the past I have had plenty of success without too many problems on extracting data from another spreadsheet, however today I ran into a problem and I was hoping someone would be able to help. I have one particular column in my spreadsheet that is causing me a lot of problems, the spreadsheet was supplied by a client and the column in question contains zip codes. The zip codes can be of the US or Canada and they have special format on this column for zip codes. When I run the query on it, the fields with Canadian zip code don't get pulled in. Any ideas as to why this is the case. -- J. Daly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Formatted Spreadsheet To SQL ? | Excel Discussion (Misc queries) | |||
Spreadsheet with 12 tabs all formatted the same. XL2003 | Setting up and Configuration of Excel | |||
plain text opens instead of formatted spreadsheet | Excel Discussion (Misc queries) | |||
Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions | |||
Values being formatted differently when opening spreadsheet using ado.net | Excel Programming |