>Does anyone know of a product that can read a data file and advise the format?

I haven't used it, but others have used this product in similar situations (used to be called DataJunction): http://www.pervasive.com/dataintegrator/index.asp


Thanks, I'll take a look