Exporting Date to txt file

[AccessHunter]

Hi,

I have a Make Table query that has the Date field as follows,
Date: IIf(IsNull([FSP date]),"",DateValue((IIf(IsNull([FSP date]),"",Format([FSP date],"mm/dd/yyyy"))))).

Query run fine and creates the table, but when I try to export it to a txt file using the export wizard it fails and gives me the message that says, "Microsoft Jet Database could not find the object". Could somone please shed some light and tell me what am I doing wrong here !!

Thanks

[Stewart Ross]

Hi,

I have a Make Table query that has the Date field as follows,

Date: IIf(IsNull([FSP date]),"",DateValue((IIf(IsNull([FSP date]),"",Format([FSP date],"mm/dd/yyyy")))))

Query run fine and creates the table, but when I try to export it to a txt file using the export wizard it fails and gives me the message that says, "Microsoft Jet Database could not find the object". Could somone please shed some light and tell me what am I doing wrong here !!

Thanks

Hi. Whatever is happening it is unlikely to be as a result of the date conversion and subsequent table export. Out of interest I tried a make-table that included a number of fields along with your string-converted date function. I exported the table to text with no problems.

You might wish to backup your database then try a compact and repair and see if your export difficulties continue.

Your string conversion for the date does not need to test for null twice:

Date: IIf(IsNull([FSP date]),"",DateValue((Format([FSP date],"mm/dd/yyyy"))))

-Stewart

ps the DateValue function is unnecessary too and can be left out altogether:

Date: IIf(IsNull([FSP date]),"",Format([FSP date],"mm/dd/yyyy"))