Import Date Issues 1

[FireGeek21]

I have exported data from Crystal Reports XI into Excel. Null dates are showing in the Excel file as 01/00/1900. When I import the file into Access, these values are now showing as 12:00:00 AM.

How can I get these "nulls" to actually show as null (or blank)???

RSGeek


RSGeek
(currently using Crystal Reports XI with Lawson 8.03)

 

[PHV]

Use an UPDATE query ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[FireGeek21]

Can you please explain?


RSGeek
(currently using Crystal Reports XI with Lawson 8.03)

 

[FireGeek21]

Maybe I'm doing something wrong... Not sure. Tried the Update Query as suggested. In the Update To field I entered the following:

IIf(tblLOAs![LOA Off]=#12:00:00 AM#,IsNull(tblLOAs![LOA Off]),tblLOAs![LOA Off])

Nothing gets changed when I run this query.

ARUGH!


RSGeek
(currently using Crystal Reports XI with Lawson 8.03)

 

[PHV]

Something like this (SQL code):
UPDATE yourTable SET yourDateField=NULL WHERE yourDateField=0

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[FireGeek21]

YYYYEEEEEEAAAAAAHHHHH!!!!!!

Thank you SSSSSSOOOOOOO MUCH!!!

Gold star for you!


RSGeek
(currently using Crystal Reports XI with Lawson 8.03)