Link Problem

[golfinray]

I am trying to link to an Excel file. Most of the fields are fine but I have
2 columns that import as #num. I tried changing them on the Excel sheet to
general number and currency (which they are.) They still show up as #num. Is
there a way to fix this? Thanks!!!!

 

[Tom van Stiphout]

On Wed, 11 Mar 2009 06:10:01 -0700, golfinray

Check with the Knowledgebase. Perhaps this one applies to your
situation: http://support.microsoft.com/kb/208414

-Tom.
Microsoft Access MVP

 

[James A. Fortune]

I am trying to link to an Excel file. Most of the fields are fine but I have
2 columns that import as #num. I tried changing them on the Excel sheet to
general number and currency (which they are.) They still show up as #num. Is
there a way to fix this? Thanks!!!!

Another thing to try:

http://groups.google.com/group/comp.databases.ms-access/msg/3bed99cc0b778c11

James A. Fortune
(e-mail address removed)