473,795 Members | 3,323 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem with an exported access report to excel

13 New Member
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
1 1647
NeoPa
32,579 Recognized Expert Moderator MVP
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

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

Similar topics

4
3950
by: D | last post by:
I've created a report with many subreports of aggregate data. I want my client to be able to export this data to Excel to make her charts, etc. Only one problem: one of the fields is a "SchoolYear" TEXT field that contains data such as 2000/01, 2001/02, etc. If I export a Query with this kind of data to Excel, it gives me the text value of this field; however, when I export a Report bound to this TEXT field, Excel gives me the values 36526,...
1
3169
by: Mustufa Baig | last post by:
I have an ASP.NET website where I am showing off crystal reports to users by exporting them to pdf format. Following is the code: ---------------- 1 Private Sub ExportReport() 2 Dim oStream As System.IO.MemoryStream = 3 myReport.ExportToStream( ExportFormatType.PortableDocFormat) 4 Response.Clear() 5 Response.Buffer() = True
3
3866
by: Blasting Cap | last post by:
I have an app that gives a user an option to pull an online report into Excel. I have the rows formatted in a couple different colors, with a grey header & footer. No matter what colors the alternating (and regular) rows are between the header & footer, they come out an off-white color. Is there a way to programatically set the colors of cells when they're
1
1523
by: arnabit | last post by:
Hi, I have a problem with excel 2007. I have gridview where a report result is being shown when the report are exported it is saved in an excel file. In excel 2003 it is working fine .But in Excel seems like Export to Excel is broken. May just be an Excel 2007 issue. Please give me a sujestion for how to approach to solve the problem. Thanks,
1
1254
by: mitchbooks | last post by:
I have a .net application that uses Crystal Reports to display reports. When a report is exported to Excel the number fields are transposed to text in Excel requiring the users to format any number columns. Any idea on how I can get the report to retain it's datatype when exporting to Excel? Thanks Mike
1
2553
by: JFKJr | last post by:
Hi! I have exported an access table data into an excel file using the following code. However, the code exported all the data to the excel sheet starting from 'A' cell (first column). But I want to export all the data into the excel starting from cell B (second column) and include the heading "Extract Policy" followed by checkboxes in 'A' cell. Can anyone suggest me how to do this? Thanks a million in advance. Function ExportTableToExcel()...
3
4358
by: evenlater | last post by:
I have an Access application on a terminal server. Sometimes my users need to export reports to pdf, rtf or xls files and save them to their own client device hard drives. They can do that right now the way I have this set up, but it's confusing and slow. When they browse for a place to save the reports, they see all of the drives on the terminal server as well as their own client drives. So they're likely to want to choose "My...
4
5953
by: Sep410 | last post by:
Hi all, I have a report in crystal report when I export it to excel each column will be shown in 2 or 3 merged columns!!! The worst part is that sometimes the header of the column is in the A and B columns but the details of this columns are in B and C in excel sheet!!! I don’t want that and I want to have normal excel sheet with the boarders around each cell what should I do? Here is the example of my exported report in excel:...
0
1291
by: shalskedar | last post by:
The grandtotal in Access REport is not matching with the total in Excel, when this report is exported from Access to Excel..... Can i get the solution for this
0
9519
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10213
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10000
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9037
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6779
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5436
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5563
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3721
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2920
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.