Why access report is exported to excel error
[Users questions | Browse:32 | Favorites]
Users questions:I used to do the database access generated reports, statements with name, sex, age, birth, identity card number, home abbot and other fields. Report shows no problem. Now I want to report the xml export to excel data sheet. I export success, is arranged in the order changed, the name rowGo back to the ID number, date of birth and other digital field, they all ran to the front of the! There are even more appalling is that as the correct ID number is 512621198808237089 512621198808237000 export xml into such a post a few anyway back to 0 allA! Will The skilled, this is why, and how to ensure export to xml format remain the same as the original report, (column ranking and value of the same)? ? ? ? ?
Experts answer:excel the xml data table? Should excel in xls table it, as some behind the ID card numberNumber becomes 0, it is not in the access field property ID number will be set to text, excel tables figures show the default figure of 15, more than 15 above shows the scientific notation, as after the commencement of the figures behind 0, and if the text, there is no such phenomenon, and I tried the guideThe data excel1997-2003 version of the xls format does not appear the problem you described, if your operation is wrong?
Experts answer:excel the xml data table? Should excel in xls table it, as some behind the ID card numberNumber becomes 0, it is not in the access field property ID number will be set to text, excel tables figures show the default figure of 15, more than 15 above shows the scientific notation, as after the commencement of the figures behind 0, and if the text, there is no such phenomenon, and I tried the guideThe data excel1997-2003 version of the xls format does not appear the problem you described, if your operation is wrong?
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.