MS Access to MS excel

[dogg909]

When I'm Access….

After a report has been generated (in Word format) I usually merge i
with MS Excel and then email it off to our clients. However the forma
of some of the fields change when this merge takes place.

The date column will be in a date format in Access but when merged wit
Excel the date format changes to a text format (what this means is tha
the properties of the date column changes when the merge takes place)
This change affects how our clients ingest the data I send them Yo
can see this by going into one of the date cells in Excel and checkin
the properties.

I am using an XP OS with Office XP and MS Access 95

Thank yo

 

[Debra Dalgleish]

If the data is in Access, you could use it as the data source for the
merge with Word.

Or if you need to import it to Excel, use one of the techniques shown
here to convert the text to numbers:

http://www.contextures.com/xlDataEntry03.html