Can't append all data

  • Thread starter Thread starter Clifford Zivi
  • Start date Start date
C

Clifford Zivi

I am using the docmd.TransferText to import an ascii file
into an Access table. I know that the 2nd line of the
import file is totally blank but I can't change the
file. When I do the TransferText I get the
error, '...was unable to append all the data to the
table. The contents of 0 records were deleted...'
Is there any way to elliminate the error from popping up?
 
Hi Clifford,

Try using
DoCmd.SetWarnings False
immediately before the TransferText, and
Do Cmd.SetWarnings True
immediately afterwards.
 
Back
Top