I have the default length for a text field set to 50 characters, but when I import a comma delimited file, all of the text fields have a length of 255.
Why is this happening and how do I fix it?
As always, thanks in advance!
You can set up the table in which you are going to put the data beforehand and specify the length, type, etc. of the fields, and then import the data using an import specification. If you are creating a new table during the import, I think your only option is to open the table design and change the field length after the import.
Yep - that’s where I think I’m headed.
Thanks for the help!