ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Transfer Date from Access- Excel (https://www.excelbanter.com/setting-up-configuration-excel/394422-transfer-date-access-excel.html)

Peter GOBLE
Transfer Date from Access- Excel
 
I have a huge data base in Access, and need to transfer to an Excel pivot table.
Dates have been formatted in Access as Dates, DDMMYYY, resetting to Text, the date remains in the same order DDMMYY, but any subsequent sorting results in the database being sorted in numerical order when transferred to Excel.
Is there any way of adjusting access so that dates remain as dates when transferred between both programmes.
thanks for listening.
Peter

Pamanabh
Quote:
Originally Posted by Peter GOBLE (Post 1396563)
I have a huge data base in Access, and need to transfer to an Excel pivot table.
Dates have been formatted in Access as Dates, DDMMYYY, resetting to Text, the date remains in the same order DDMMYY, but any subsequent sorting results in the database being sorted in numerical order when transferred to Excel.
Is there any way of adjusting access so that dates remain as dates when transferred between both programmes.
thanks for listening.
Peter

Hi Good evening !!!!

Can you please attach sample data, so that its can be more clear to study.


All times are GMT +1. The time now is 04:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com