<p>Was wondering if there was a way to put a wildcard in the schema.ini for example
[*.txt]
FMT=TabDelimited</p>

<p>I've got an app that is imported tab delimited files and the only place I can seem to get the FMT="TabDelimited" is in the schema.ini (doesn't work in the connection string for some reason), but I will have no idea what the filenames are other than the txt extension.</p>

<p>BTW I'm connecting using an OdbcConnection and the Microsoft Text Driver.</p>

[{'answer_id': 75632, 'author': 'Jeremy Coenen', 'author_id': 7798, 'author_profile': 'https://Stackoverflow.com/users/7798', 'pm_score': 2, 'selected': True, 'text': "<p>I guess I could potentially rename the file temporarily to match whatever I decide to put in the schema.ini or potentially modify the schema.ini on the fly and put the correct filename in there, but I'd love to do know if there was a better way.</p>\n"}, {'answer_id': 145807, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 0, 'selected': False, 'text': '<p>A single schema.ini file can contain multiple\n[fileName.txt] entries and format \ndescriptions, (for all the files in the \nDirectory), so you might consider creating the .ini\nfile dynamically from the directory file names. </p>\n'}]
['https://Stackoverflow.com/questions/73576', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/7798/']