Errors in importing text document to Access 2000 table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!
while importing text using file menu, the file is imported and an error
report is generated which has no efffect on data.

while doing the same using TransferText method the same says unparse-able
data and the text is not imported. This is probably due to use of " and ; in
the file. here ; is the delimiter. hoe to resolve the problem.

Please help.
Amit
 
I find that to maximize the probability of a successful text import that is
always best to semi-manually clean/normalize the text using the word
processor first.

Usually this means doing the basic search & replace for symbols that are to
make the fields unique so there are no duplications or to insert where
necessary.

Sometimes this is alot of work and one must be realistic - - it all depends
on the original text situation. There is limits to what one can do and also
limits to what one can expect from "artificial intelligence" in Access
understanding or interpreting a text file.....

hope this helps a little....
 
Back
Top