Exporting to Excel
-
- Posts: 14
- Joined: Tue Oct 10, 2017 12:44 pm
Exporting to Excel
When exporting to an Excel file in R&R 10+ the following data gets bought through. The Contact Date/Time field should be a date / time stamp from an Access database. This has also been tested against other database platforms. We are using the latest 10+ EXE^s and Excel 2002. If exported to CSV, or run through the report preview it is OK, as well as actually pulling the data directly into Excel using MS Query.____Customer Name_Contact Date/Time__51 _ ¨:___138 _ ¨:___26 _ ¨:___379 _ ©:___254 _ ©:___15 _ ©:_____Any ideas?____Richard Ward__Warwick International Computing Systems__
=> RE: Exporting to Excel
I just tried one and got the same bad result as you.__So we will need to investigate further here.__As a workaround you could create a calculated field that converts the date to a character and then use that character field on the layout in place of the date.____Kathleen__R&R Support