by "bhicks11 via AccessMonster.com" <u44327@[EMAIL PROTECTED]
>
Aug 7, 2008 at 11:26 AM
I'm using Access 2003 and the first trick you did works for me and doesn't
put #NUM! for the numbers?? Not sure why you are getting that.
Bonnie
http://www.dataplus-svc.com
SupperDuck wrote:
>Hello,
>
>My problem occurs only in one column that contains both text & numbers.
>
>748906
>310/E
>91157656
>AKS-?EKER
>17271927-29
>
>These are some of the values in the column.
>
>I have given a text to the first line of the excel to trick the Access to
>take it as "Text" column. But when i do this, the values (such as 748906)
are
>seen as "#Num!". If i do not do this, it can see as number and so the
other
>datas which are not numbers are seen as "#Num!"
>
>How can i solve this... I use some excel macros before i save the excel
so
>your suggestions can include excel side (macros) do to something to solve
the
>problem.
>
>Thanks in advance,
>
>Regards,
>
>Veysel
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200808/1
