Hi AllI have a problem - I am importing an excel *csv file and the import works fine with one exception relating to 1 data file field.In the table I have the Data Type defined as "Short Text" the problem I have it would appear Access is trying to be clever on the input and thinks this particular field is actual Time/Date data. The field being imported relates to an account code which format is n-nnn-n (where "n" is a number), the problem is that this imports as a time/date.I have tried changing the Data Type to just about ever possible option but with no luck. The file does import ok when *.xlsx or *.txt, the problem is that I am trying to automate the whole process and the source data generated as *.csv and I don't really want to have to open each file and save the format as .txt or xlsxAny ideas/clues ???ThankdsAlex