Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Location: North Yorkshire
Posts: 1
Default 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   Report Post  
Junior Member
 
Posts: 10
Default

Quote:
Originally Posted by Peter GOBLE View Post
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access transfer to Excel Deb Pingel[_2_] Excel Programming 2 June 28th 06 10:02 PM
Transfer data from Excel to Access Secret Squirrel Excel Discussion (Misc queries) 1 March 27th 06 12:07 AM
ADO Transfer from Excel to Access Secret Squirrel Excel Discussion (Misc queries) 0 March 26th 06 11:50 PM
Transfer data from Excel to Access SecretSquirrel Excel Programming 0 March 25th 06 08:13 PM
Transfer of data from excel to access Chris B.[_2_] Excel Programming 0 December 9th 03 01:30 PM


All times are GMT +1. The time now is 11:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"