SteveE
08-19-2008, 07:09 AM
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
08-19-2008, 11:32 AM
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?