Export Access Tables to Excel

[petetipavan]

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.

 

[MarkAndrews]

Hello & Welcome

You can simply custom format the cells in Excel

Select the column > Format > Cells > Time

Select the format you require

 

[petetipavan]

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.

 

[MarkAndrews]

You could change the raw SQL in the query? (if you know how)

 

[petetipavan]

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?