I'm trying to import a large CSV file (700,000+ rows) directly into a table. Some columns in the CSV file are nearly all numeric except for an occasional character. Knowing this I set the field in the table I am importing into as Short Text. Access seems to ignore this and treats the field as if it is Long, consequently the character strings which will easily fit into the field are ignored.
I have a similar problem with another field, this is all numeric, however the number is too long to fit into Long, so I set the field to Short Text again. Again Access thinks it knows better and imports as Long, then doesn't save it as the number won't fit into Long.
I also have similar problems with dates, The CSV file occasional has something like -/-/1986. I ask for it to go into a text field, but again it ignores the field type.
Altering the CSV file is not really an option. Any suggestions much appreciated.
R