Import file error

[Luis]

Hello.
I have a module that imports a .txt file into an existing table.
I'm having a strange problem with the import operation.
When i import the file i get a Run-Time Error 3207 - Property not found.
If i close the database and re-run the module it runs perfectly.
The behavior is always this, one time works, the next doesn't works, and so
on..

Can anyone give me a hint?

Thanks

Luis

 

[John Spencer]

It would help if you posted the code you are using.

Terminology: You have a module that contains procedures (functions and
subs). The procedures are what do the work.

I am going to be offline for most of the next few days, so hopefully
someone will respond with some idea of how to handle the problem after
you post the code.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================