So I have a column in a .txt file with values such as 123, 342, H425, AB31, etc..
When i first imported it then Access defaulted it as a text, and when I try to run a query using that field, the ones with the letters in it return the error #NUM!.
Logically then I reimport it was a "text" field, and the query runs finely with all values in there, HOWEVER, when I try to use an AutoExec macro on there, I get this error:
"microsoft office access was unable to append all the data to the table"
"the contents of fields in 1802 records were deleted", etc..
Now 1802 is the # of fields that contain letters, while the other 500 or so contain all numbers.
Any suggestions?
edit: Got it working now, just had to reimport the feed from scratch and that seemed to do it for some reason.
When i first imported it then Access defaulted it as a text, and when I try to run a query using that field, the ones with the letters in it return the error #NUM!.
Logically then I reimport it was a "text" field, and the query runs finely with all values in there, HOWEVER, when I try to use an AutoExec macro on there, I get this error:
"microsoft office access was unable to append all the data to the table"
"the contents of fields in 1802 records were deleted", etc..
Now 1802 is the # of fields that contain letters, while the other 500 or so contain all numbers.
Any suggestions?
edit: Got it working now, just had to reimport the feed from scratch and that seemed to do it for some reason.
Last edited:
