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

Problem with an exported access report to excel

P: 13
I'm trying to export an access report to excel and have run into a problem. One of my fields is a text field and when it is exported to excel some of the data values show up correctly and some are given by a serial number (date format). Here is my data

067-02
067-01
196-00

196-00 appears correctly but 067-02 and 067-01 are converted to a serial date number. Is there any way to prevent this from happening?

Another report generated consists of:
061-00
065-00
These text strings appear correctly in the exported excel sheet.

Thanks for any insight.
Aug 28 '08 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,473
I don't know how helpful you'll find this, as I'm not aware of a way to force this behaviour onto Excel. You could try reformatting the column after opening it in Excel, but no guarantees there.

What I would suggest though is that exporting a formatted display (report) into Excel, although supported, is not an ideal way to transfer the information (Being as diplomatic as I can here).

If you have a report in Access, it's almost certainly more useful to export the underlying data-source itself. Excel can handle pretty well any fiddling of the data that a report can anyway, and you're more likely to want to work with the raw data anyway (far more predictable and reliable).
Aug 28 '08 #2

Post your reply

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