Exporting to Excel

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Richard_Ward_(Guest)
Posts: 14
Joined: Tue Oct 10, 2017 12:44 pm

Exporting to Excel

Post by Richard_Ward_(Guest) » Tue Feb 03, 2004 10:22 am

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__

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Exporting to Excel

Post by kfleming » Tue Feb 03, 2004 3:34 pm

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

Post Reply