J
Jack Chung
Hi,
I have an access 2007 db, and I link a .txt file into the db, and then
I have multiple queries created off of that .txt file. I now want to
export those access queries into excel, and I find that when I export
1 query it works fine, but when I try to export 2 or more, I get an
error stating that the db is already in use.
This problem doesn't come up for me when I export multiple access
tables into excel; it's just for access queries. The reason that I
want to use access queries instead of tables is so that when I update
the .txt file, I won't have to go into access to make new tables.
Has anyone else experienced these issues with exporting multiple
access queries into excel?
I have an access 2007 db, and I link a .txt file into the db, and then
I have multiple queries created off of that .txt file. I now want to
export those access queries into excel, and I find that when I export
1 query it works fine, but when I try to export 2 or more, I get an
error stating that the db is already in use.
This problem doesn't come up for me when I export multiple access
tables into excel; it's just for access queries. The reason that I
want to use access queries instead of tables is so that when I update
the .txt file, I won't have to go into access to make new tables.
Has anyone else experienced these issues with exporting multiple
access queries into excel?