onhold-rpt_ImportErrors

[SteveE]

I have a text file import routine which work fine, but because of the file "make-up" I always get a portion of the header rejected (this is not required) and this creates an access default ImportErrors table. This routine is run several times a day which created many error tables which are just not required. Is there some way I can turn off this table creation? I did have a smaller routing which just deleted the table if it existed but this caused bloating of the DB I am using Access 2000

any advise appreciated
Steve

 

[Alisa]

I have a text file import routine which work fine, but because of the file "make-up" I always get a portion of the header rejected (this is not required) and this creates an access default ImportErrors table. This routine is run several times a day which created many error tables which are just not required. Is there some way I can turn off this table creation? I did have a smaller routing which just deleted the table if it existed but this caused bloating of the DB I am using Access 2000

any advise appreciated
Steve

I don't know the answer to your question, but why not just delete the table if it exists at the end of your routine?