Type conversion error

[corymw]

I have a database set up where each table will be manually updated once per month with a .csv file.

When I import the CSV originally, I can manually set the Data type of the field "Project Number" to text. My plan is to delete all of the records in the table, then append the new CSV to that same table each month.

However, when I use the append tool, my long project numbers get a "type conversion failure". This would make sense if they numbers, as they are too long. However, the original table has project number as a "Text" data type. Why are they not importing as text?

[JoeM]

Are you using a pre-defined Import Specification when importing your CSV file?
If not, you should create one, and then use that on your Imports (and obviously make sure that Import Specification has that field format set to Text also).