I really need to be able to create an ODBC DSN for a text file using the Microsoft Text Driver. I've neaver had any troubles doing this for Databases, but the connection string for the text driver baffles me.

Is it necessary to do something additional for the text driver? as I can't see anywhere in the DSN to define the columns etc - even in the registry the format is completely different.

If anyone could point me in the right direction, or give me an example of a working string I will be eternally grateful as the system I'm working on is supposed to go into test tomorrow.

Thanks

Mace