Okay - it's me again. I guess I'm going to have to find a way of paying back for all the help I've got from here. I have a really bizarre problem. I'm trying to export from Access 2 text files which later on combine into one.
I have tried all sorts. If I change it to export excel files, it works.
I tried creating a new database and running each line separately in each db. When I did that the one that wasn't working before worked, but then the previously working one, stopped working.
The error message I get is: Run-time error 3011: "The Microsoft Jet Database engine could not find the object tblHeaderOutput#txt. Make sure the object exists and that you spell its name and the path name correctly.'
It seems to be seeing the .txt as #txt.... I've been trying to work round this for the past 6 hours. Has anyone got any insight into this?
Have a Merry Christmas all and thanks for your help so far.