Hello,
I have a text file containing mixed text and numeric data - It's pulled from a warehouse management system. The data comes off in 'pages' with the header text repeated at the top of each page. Problem is - I have my link to Access set with a link import specification. The spec imports numeric data as double & long integer - however, when the linked data is viewed in Access, the repeated text headers are each replaced with a '#Num!' error... which is understandable.
I then attempt to use the linked text file in a Make Table query, with no criteria such as 'Is not null' etc, it simply makes a table for me to append to - which tends to run fine the first time - but if you try to run again, and overwrite the previous table, it fails with the error:
"You cannot record your changes because a value you entered violates the settings defined for this table or list (for example, a value is less than the minimum or greater than the maximun). Correct the error and try again."
Does anybody know of a good method for dealing with importing columns containing mixed data types, to avoid/workaround this problem?
It's probably clear that I'm a novice in Access, so any help appreciated.
Gregg