No...wait! That code I gave you works. There is only one more line of code needed! I don't mind helping, you've done the hard part.
No...wait! That code I gave you works. There is only one more line of code needed! I don't mind helping, you've done the hard part.
I got it to work, it had to do with the import specs within access. I had to start to import the txt file and click on the advance button, in there I was able to create a spec that labelled the field names and using you variable it all worked out great. I am greeatly appreciated for your help and can't thank you enough.
You're welcome! Glad it is working.