Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
#Num in linked acess table
Name: sam78 Date: December 7, 2005 at 03:11:35 Pacific OS: XP CPU/Ram: p4
Comment:
Im getting #Num in a linked ms access table where the data is "1.0" in the spreadsheet (without the speachmarks), there are other cells in the same column with "1.0 prov" which are fine.
Have tried the macro that Microsoft provide to sort this but it just causes the problematic cells to vanish from the spreadsheet leaving blank entries.
The field is set to Text in access which I thought should be able to handle numbers also? however this cant be changed in Access and changing the format type in Excel has no effect as Access likes to decide on the data format itself when using a linked table.
I can import the data into a normal access table with no problems.
Any ideas would be greatly appreciated!! this is really doing my nut!!
Summary: I have 6 linked Excel tables in an Access database. Four of the tables are fine, but 2 of the tables have a problem with one of the columns. Data is entered into these tables daily. The columns are fo...
Summary: Hello, How do I hide zero values in a Pivot Table? The data behind the zero is an equal positive and negative, hence, zero! I think I need to create another calculated field and having problems in doi...
Summary: I have an Excel S/sht which is linked in MS Access. The fields can be either text, numeric or both. I get #Num! errors in the Access version of the Excel S/sht, the data type is wrong but I can't fix ...
