Ok, this one's driving me absolutely nuts:
I've been using Excel's Query wizard for some time now to do SQL-type extractions, but I'm befuddled on this one. I'm attempting to query a .csv file, but for some reason all the cells are returning as text values, even though there are either numbers or dates ~only~ in them. If I go to one of these cells, push F2, then enter, it assumes its proper numerical value. If I open the .csv file into Excel, all the number-type values are reading as they should.
Can anyone help on this? Is there a way to set up the text driver in the Data Extraction wizard to accept numerical values? I'd even settle for a macro or VBA code that activates when the data is pulled; the only issue with this is I'm pulling 45,000+ rows and up to 100 columns at a time.
PLEASE HELP!
Thanks in advance
~ Thomas
I've been using Excel's Query wizard for some time now to do SQL-type extractions, but I'm befuddled on this one. I'm attempting to query a .csv file, but for some reason all the cells are returning as text values, even though there are either numbers or dates ~only~ in them. If I go to one of these cells, push F2, then enter, it assumes its proper numerical value. If I open the .csv file into Excel, all the number-type values are reading as they should.
Can anyone help on this? Is there a way to set up the text driver in the Data Extraction wizard to accept numerical values? I'd even settle for a macro or VBA code that activates when the data is pulled; the only issue with this is I'm pulling 45,000+ rows and up to 100 columns at a time.
PLEASE HELP!
Thanks in advance
~ Thomas