Export results to Excel not correct

G

Guest

I am experiencing a problem in trying to export a result
of a query to Excel 2k from Access 2k. The query results
are correct but I have a few date fields that are not
being exported properly. For example, a planned end date
in the query results is 6/15/04 but when exported the date
for this record is blank. This is happening on several
records of a total results set of 77 records. Any ideas
as to what to do or what the problem may be? I can have a
co-worker run the same query from their computer with the
same software versions and service packs installed and
they do not have a problem.

Thank you -
 
B

BrianB

I suggest you make it a "Make Table" Query and import that to Excel. Yo
get more control of formatting
 
J

Jamie Collins

I am experiencing a problem in trying to export a result
of a query to Excel 2k from Access 2k. The query results
are correct but I have a few date fields that are not
being exported properly. For example, a planned end date
in the query results is 6/15/04 but when exported the date
for this record is blank. This is happening on several
records of a total results set of 77 records. Any ideas
as to what to do or what the problem may be? I can have a
co-worker run the same query from their computer with the
same software versions and service packs installed and
they do not have a problem.
Click to expand...

Same data too?

Also, check the regional settings for date format (Control Panel) on
each machine. Are they the same?

Jamie.

--
 
Top