Connecting Tech Pros Worldwide Forums | Help | Site Map

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

1978fx@gmail.com
Guest
 
Posts: n/a
#1: Jul 14 '06
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


1978fx@gmail.com
Guest
 
Posts: n/a
#2: Jul 17 '06

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


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.


1978fx@gmail.com wrote:
Quote:
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
Closed Thread