Export Access Tables to Excel

petetipavan

New Member
Joined
Sep 13, 2006
Messages
5
I have a tool made around MS access and VBA. It is basically a report generating tool. When I export the records resulted from a query to excel spreadsheet, the time stamp does not show in excel, Excel just shows the Date. The date and timestamp format is not kep in the excel. I would appreciate if any one could provide solution for this issue.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
Hello & Welcome

You can simply custom format the cells in Excel

Select the column > Format > Cells > Time

Select the format you require
 

petetipavan

New Member
Joined
Sep 13, 2006
Messages
5
Thanks for the reply, is there a way to programitically change the format of excel column before exporting the records to it. When I export the file to excel it should just display Date and Time as well without me doing any modifications to format of cells.
 

petetipavan

New Member
Joined
Sep 13, 2006
Messages
5
Yes I can change the raw SQL, can you please provide me the solution for this issue. Can anything be done at the SQL end?
 

Watch MrExcel Video

Forum statistics

Threads
1,114,091
Messages
5,545,906
Members
410,711
Latest member
Josh324
Top