I've had the wizard incorrectly guess the longest field length as well since it does sample (it's also slow). Reading the file twice in some fashion seems the best way. I usually check it low level first to find the longest fields without storing the data and then do a simply import after creating a blank table. However, if the file is small enough I suppose one could populate an array, create the table and insert from array.