I am having a problem after creating a query and exporting to excel, it doesn't sort the date correctly. I tried to use tools and analyze with excel but it does the same thing. When exporting i click the save formatted button. None of these works. Any help out there. Thank you.
excel sorting problem
- Thread starter dgb
- Start date
pdx_man
Just trying to help
- Local time
- Today, 01:10
- Joined
- Jan 23, 2001
- Messages
- 1,347
What is the datatype of the field you are exporting? I'm guessing text and not a Date/Time. Try creating a field that is formated for a Short Date. Depending on how your data is stored, you may have to parse differently.
Check out these functions:
CDate
Format
DatePart
Mid
Check out these functions:
CDate
Format
DatePart
Mid
pdx_man
Just trying to help
- Local time
- Today, 01:10
- Joined
- Jan 23, 2001
- Messages
- 1,347
Hmm, this is something that I do on a daily basis and have never had any problem exporting dates ...
Let's see:
What does the data look like in Access?
What does the data look like in Excel?
If you go to the Format Cells in Excel, what is the format for one of the cells in question?
What happens if you select one of the Date formats?
Try using the CDate() function in the export query.
Let's see:
What does the data look like in Access?
What does the data look like in Excel?
If you go to the Format Cells in Excel, what is the format for one of the cells in question?
What happens if you select one of the Date formats?
Try using the CDate() function in the export query.
Similar threads
