By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,501 Members | 2,681 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,501 IT Pros & Developers. It's quick & easy.

"Microsoft Jet database engine cannot open the file..."

P: n/a
I'm trying to EXPORT the results of a query to a CSV file. I've been
doing this, using different queries, for WEEKS, with no problems. This
file always thinks that the resulting export file is already opened,
but the file resides on my hard drive, and I get the error even if I
delete the file and start from scratch.

I'm not doing this via programming; just FILE EXPORT.

Any ideas?

Thanks

Jul 14 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Let me add that, if I replace all the "NULL AS..." fields in my query
with
"" as...
the export works. HOWEVER, I have about 10 other queries that do this,
with "Null as..." and work just fine.
19****@gmail.com wrote:
I'm trying to EXPORT the results of a query to a CSV file. I've been
doing this, using different queries, for WEEKS, with no problems. This
file always thinks that the resulting export file is already opened,
but the file resides on my hard drive, and I get the error even if I
delete the file and start from scratch.

I'm not doing this via programming; just FILE EXPORT.

Any ideas?

Thanks
Jul 17 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.