Invalid Argument When Exporting As CSV

[mcl]

I've been trying to export the output of a query as text (csv) using the
text export wizard. When I get to end and hit finish I get "Invalid
Argument". I can export as an excel file fine but not text. Of course it
doesn't tell me what argument is invalid. Any ideas?
I'm using Access 2000.

 

[mcl]

Checked the knowledge base. It's a known problem with Access 2000. But the
work a round causes it's own problems. How come there isn't a patch to fix
this?
The problem is I have some nulls. I'm supposed to use either CDbl, CSng, or
Cint. But if I use them and there is a null I get an error.