| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
Quote:
Hi Good evening !!!! Can you please attach sample data, so that its can be more clear to study. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Access transfer to Excel | Excel Programming | |||
| Transfer data from Excel to Access | Excel Discussion (Misc queries) | |||
| ADO Transfer from Excel to Access | Excel Discussion (Misc queries) | |||
| Transfer data from Excel to Access | Excel Programming | |||
| Transfer of data from excel to access | Excel Programming | |||
Hybrid Mode
