Thank you!!! Your suggestion worked brilliantly. I was focused on the line referring to strTableName and did not even consider the problem could be elsewhere. Kudos.
Thank you for your prompt response.
The error message I received is:
Line: 7
Char: 1
Error: Query input must contain at least one table or query
Code: 80004005
Sourcee: Microsoft Jet Database Engine
I have a script that extracts data from an Access database. The tables that need to be extracted are listed in a .txt file. The script works just fine until a table is encountered that has a space embedded in the table name. When I tested my guts of my function that does the extract and I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.