Thanks but I tried both of those suggestions already. The first database file I opened has "AC" as the code in the first column, and "111" as the code in the second column. there are only two rows of data. The model treats the first row as bad data. If I ignore it, the first field is automatically treated as numeric data. If I then go to the field properties, the Type column is greyed out and I can't change it from numeric to character. I've tried doing this from the Field List as well, but when I drop down the Type column, character is not listed...it only gives me options for changing the format. :confused:
You will find a field called schema.ini in the same folder as your text file. Edit this, and in the section relating to your file, add the following lines
Col1=Field1 Text Width 10
Col2=Field2 Text Width 30
You can use your own names rather than field1, field2, and of course, you'd need to add a line for each field and check the field types and lengths.
Take a look at [url="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp"]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp[/url] for the full info.