linking from excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pierre - 14 Jul 2005 21:06 GMT

Hi all,

I link an excel file.

In a row, i have mixed type

some are seen as text, some as number

i.e. in one colum

a1234
234
b4
1

If i look at the link table i see a message # NUMBER!
each time the excel data is a number
and i see the correct data when it is a text.

How can i solve that simply?

Actually i use a function manually in excel to convert everything in text
then import
but i want to automatise that as much possible

any clues?

regards
Pierre

Reply to this Message

Van T. Dinh - 15 Jul 2005 01:02 GMT

See replies to the thread "Import Excell Numbers as Text" by Ken Nicholas in
this newsgroup about 30 hours before your post.

Signature

HTH
Van T. Dinh
MVP (Access)

> Hi all,
>
[quoted text clipped - 25 lines]
> regards
> Pierre

Reply to this Message

Dodo - 16 Jul 2005 13:07 GMT

> See replies to the thread "Import Excell Numbers as Text" by Ken
> Nicholas in this newsgroup about 30 hours before your post.

It is sometimes difficult to find old messages back. It is not so difficult
to repeat the text:

For a mixed Column in Excel, I normally create a "calculated" Column in the
spreadsheet using the Excel Spreadsheet function like:

= Text([CellInMixedColumnAnsSameRow], "General")

This converts all values to Text regardless of the data type in the mixed
Column.

When I import, I skip the mixed Column and import the "calculated" Column.

Signature

HTH
Van T. Dinh
MVP (Access)

Reply to this Message

Van T. Dinh - 16 Jul 2005 14:35 GMT

I used Outlook Express and there is no problem finding recent posts.

And there is Google Groups search as well.

Signature

HTH
Van T. Dinh
MVP (Access)

> It is sometimes difficult to find old messages back. It is not so
> difficult
> to repeat the text:

Reply to this Message