When I use ODBC to import data into Excel, all numbers come through with a
leading apostrophe so that Excel sees them as text.
e..g INSERT INTO [Sheet1$] VALUES (10) will come into Excel as '10
When I use ODBC to import data into Excel, all numbers come through with a
leading apostrophe so that Excel sees them as text.
e..g INSERT INTO [Sheet1$] VALUES (10) will come into Excel as '10
Ooops .. Sorry I forgot to state my question... how do I stop numbers
appearing as text?
Thanks!
"LarryPH" wrote:
> When I use ODBC to import data into Excel, all numbers come through with a
> leading apostrophe so that Excel sees them as text.
> e..g INSERT INTO [Sheet1$] VALUES (10) will come into Excel as '10
ODBC likes to use strings (text) for its output because text is safe. Any
number chan be shown as text but text can not necessarily be converted to a
number. That having been said so long as you know there are a couple of
things you can do. You cna use a macro to convert the strings or in a column
next to the text use the formula =value(A1)...
HTH
"LarryPH" wrote:
> Ooops .. Sorry I forgot to state my question... how do I stop numbers
> appearing as text?
> Thanks!
>
> "LarryPH" wrote:
>
> > When I use ODBC to import data into Excel, all numbers come through with a
> > leading apostrophe so that Excel sees them as text.
> > e..g INSERT INTO [Sheet1$] VALUES (10) will come into Excel as '10
LarryPH wrote:
> how do I stop numbers
> appearing as text?
Although written from the opposite perspective, there may be something
of use here:
http://www.*****-blog.com/archives/2...ed-data-types/
Jamie.
--
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks