Exported excel file has no formatting

[tommy_mo]

I've posted this question in the Excel Forum, but maybe it's better suited here. I need some help with an excel file that is created from an Access Query. I’ve managed to create a button on my form that creates the .xls file and open excel, but the formatting is wrong. I need to define the columns in date and time format so that the created file looks right. I’ve already tried one suggestion to change the default .xls file to be the format I need, but that didn’t help. Is there any way to do that? I really appreciate any help I can get. Cheers. -Tom

 

[Brianwarnock]

Are you sure that your query is producing the correct format?

If you are producing a Date it will export a date and show as a date, ditto time, date and time will only show the date unless you preformat the spreadsheet with a custom date and time, but I think the time will be present.

Brian

 

[tommy_mo]

Thanks for the response. You were correct. I just had to change the format properties for my query. I'm just getting started w/ Access so the little things still throw me for a loop. Cheers!! -Tom

 

[Brianwarnock]

Glad to help as will all the contributers to this forum.

Brian