date field not recognized when exported to excel from access

M

masassy

when i try to export my report from access to excel I loose the my booking
month which is a text field in the format of mmm-yy (ex. jan-07). For some
reason as a text I get some where 5 digit number for the booking month field.
I had it as a date field before this and it would assume that the year was
the date and change everyting to the correct month but to the current year.
Does anyone know how I would be able to fix this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top