M
mrhartwig
Hi there. I have been trying to link an excel spreadsheet to an
access table all day and have been running into a problem that seems
pretty common. Unfortunately, all the tips I've seen posted have not
resolved my error. I have a spreadsheet with approximately 15
columns. All the columns but 1 will link to access without any
problems. I have 1 column that contains data similar to this: 315.991
For some reason most of the data is coming over but out of 791 records
approximately 100 give me the #NUM! error.
I've tried changing the format in excel to text.
I've tried inserting "dummy" fields above my data to trick access into
formatting all my data as text.
I've even tried the following Macro:
Public Sub FormatAsText()
Dim cell As Object
For Each cell In Selection
cell.Value = " " & cell.Value
cell.Value = Right(cell.Value, Len(cell.Value) - 1)
Next
End Sub
This one sort of worked.....it dropped the 1 digit off all my data.
So instead of 315.991 it was 15.991.
Any other ideas out there? Any information would be greatly
appreciated! Thanks so much!!!
--Michelle
access table all day and have been running into a problem that seems
pretty common. Unfortunately, all the tips I've seen posted have not
resolved my error. I have a spreadsheet with approximately 15
columns. All the columns but 1 will link to access without any
problems. I have 1 column that contains data similar to this: 315.991
For some reason most of the data is coming over but out of 791 records
approximately 100 give me the #NUM! error.
I've tried changing the format in excel to text.
I've tried inserting "dummy" fields above my data to trick access into
formatting all my data as text.
I've even tried the following Macro:
Public Sub FormatAsText()
Dim cell As Object
For Each cell In Selection
cell.Value = " " & cell.Value
cell.Value = Right(cell.Value, Len(cell.Value) - 1)
Next
End Sub
This one sort of worked.....it dropped the 1 digit off all my data.
So instead of 315.991 it was 15.991.
Any other ideas out there? Any information would be greatly
appreciated! Thanks so much!!!
--Michelle