|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
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.
The errors are:
"Microsoft Jet Database Engine cannot open the file...It is already
opened exclusively by another use, or you need permission..."
"An error occurred trying to export data from table...The data was not
exported."
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.
Any ideas?
Thanks
|
|
|