By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,377 Members | 1,726 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,377 IT Pros & Developers. It's quick & easy.

Help with formatting an excel spreadsheet

P: 15
hi guys. i am currently using ms access 2003. i want to export my reports to an excel file so i did a code like this:

Private Sub cmdActiveListByEmployeeID_Click()

On Error GoTo Err_cmdActiveListByEmployeeID_Click

DoCmd.OutputTo acOutputReport, "AlphaListing", acFormatXLS, , True

Exit_cmdActiveListByEmployeeID_Click:
Exit Sub

Err_cmdActiveListByEmployeeID_Click:
MsgBox Err.Description
Resume Exit_cmdActiveListByEmployeeID_Click
End Sub

the problem is that when the reports are being exported, data such as dates are not displayed properly on excel. the dates are converted into texts. fonts do also vary. how can i be able to format the excel spreadsheet so that the reports will be shown properly?

thanks in advance...
Oct 3 '06 #1
Share this Question
Share on Google+
3 Replies


P: 3
Did you try to run the report from a query and then in datasheet view and then "Tools/Analyze in Excel?
Oct 3 '06 #2

P: 15
hi, thanks for the reply. yup, but will that option be available when i make an MDE file of that database? and as much as possible, i want to make the database formal and user-friendly since i won't be the end-user of this database.and i think it would be better to create buttons for report generations... =)
Oct 4 '06 #3

PEB
Expert 100+
P: 1,418
PEB
Hi,

Have you tried to format your date in your query?

Maybe it's better to use Cvdate([Your Date]) in your query!

And I suppose that your date will appear as date in Excel conforming your Regionnal Settings...

If this don't work there is others ways to resolve the problem...


Best regards..
Oct 8 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.