#Num! Error in Link to Excel

  • Thread starter Bryan in Bakersfield
  • Start date
B

Bryan in Bakersfield

I am getting a Num! error from some records when linking my Access 2000 db to
an Excel spreadsheet.

The spreadsheet consist of names and SSNs. The SSNs are usually added with
the dashes in them (999-99-9999).

Occasionally cells are pasted from another Excel spreadsheet that uses the
Excel SSN Format. This causes the SSNs to be added without the dashes - what
looks like 999-99-9999 on the spreadsheet is actually 999999999.

When I look at the data through the link in my Access db, the standard SSNs
show up fine, but the numbers without the dashes give the Num! errror and the
rows are not imported in my append query.

Short of changing the data before I import them, is there anything I can do
to stop the Num! error? I thought the Num! error was for instances where
there is text in place of numbers, but I seem to be having the opposite
problem. I can make a macro in Excel to fix the format, but that seems
pretty half-assed.

Why is Access giving errors for having numbers in a text field? Is there
anything I can do to fix it?


For MVPs ===> Yes, I must use SSNs. No, I cannot change from using SSNs -
it would literally take an act of congress. The database is in a secure
building on a secure server that is not connected to the internet or any
other outside source.
 
B

Bryan in Bakersfield

I changed the IMEX to 1 and now it seems to work.

I can't find anything about this issue - must be another Microsoft
'Undocumented Feature'.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top