Hi all,
I am trying to find a way to pull a query from an excel list without MS Query assuming the format... I have in 1 column both numbers and text and wish to be able to pull all of that information. (Standard queries either guess the column is text and doesn't bring the numbers or guesses the column is numbers and ignores the text)
I know there is a way of changing the registry to do so, however this would require me to do this on the entire network which our IT department will not hear of.
I am competent in VBA and Excel so if anyone has a workaround in either please let me know...
(My current workaround involves having blank rows in my list which I change to whichever format I want - then do 2 queries and merge in the final file)
I am trying to find a way to pull a query from an excel list without MS Query assuming the format... I have in 1 column both numbers and text and wish to be able to pull all of that information. (Standard queries either guess the column is text and doesn't bring the numbers or guesses the column is numbers and ignores the text)
I know there is a way of changing the registry to do so, however this would require me to do this on the entire network which our IT department will not hear of.
I am competent in VBA and Excel so if anyone has a workaround in either please let me know...
(My current workaround involves having blank rows in my list which I change to whichever format I want - then do 2 queries and merge in the final file)