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.
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.