I'm trying to generate specifications files in Access automatically (in code) to handle different formats of CSV files.

i.e. I read in the 1st line containing the column names and then create a new spec in the MSysIMEXSpecs & MSysIMEXColumns tables to force all fields to come in as text.

It works fine except some files insist on a spec filetype in MSysIMEXSpecs of 1200 and others of 1252 and I can't figure out which wants what except by trial and error.
Apparently, 1200 is for unicode and the 1252 is Latin something.

Does anyone know if there's a way around this or if there's a way I can test the data file, via code, to see if it's unicode etc?

Thanks, DaveBo