Can't append all data

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?
 
J

John Nurick

Hi Clifford,

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