I'm trying to import a 20MB text file. I receive err msg "Can't start the import wizard. The first row of your data file is too large." when manually importing and Access locks up when I use 'docmd.transfer text'.
rows have a character length of 4082-4090
there are no carriage returns, there is no separator between the last character of one record and the first character of the next record. The last field of each record contains the data "mm/dd/yyyy".
I have created a new text file with just one record in order to create an import spec to use for this file. no luck.
Any and all help/insight appreciated