When I am importing a text file for appending to an existing Access table I am having problems with the import wanting to define a field as a number when it needs to be text. As a result I am getting import errors as there is text ultimately showing up in the field. Why doesn't an Access import for append take on the field properties of the table being appended to?
What is a better way of importing the data without having to import into a new table each time and then append? Or, am I approaching this in the wrong way? Thanks. - Reilly