The code in the article copies the text from the original file to a new
file, replacing Null values with blank spaces in the new file. The variable
'strOrigFile' should point to the original file, the variable 'strNewFile'
should identify the name and location for the new file which the code willReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10216
create and to which the changed data (with Null values replaced by spaces)
will be written. After executing the code, you should then hopefully be able
to import from the new file.
Of course, this would only help if the problem was actually caused by Null
values in the text file in the first place. If the problem really was causedReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10216
by having more than 65,000 characters per line in the file, you could use
code, somewhat similar to the code in the article, to copy the data from the
original text file to two new ones, dividing the original single lines into
two shorter ones, one in each file.
Of course, if you were going to have to write code like that to get the
import wizard to work, you might be as well off by-passing the wizard
altogether and writing your own import code.
"Wayne & Carr" wrote in message
> It seems that there was some problems with my Imported Text File
> That was throwing up this Error.
> But just in case I do hit this limit.
> Any and all information that anyone can assist me with will be great.
> Thank You