?
Solved

Export to CSV

Posted on 2011-09-20
11
Medium Priority
?
836 Views
Last Modified: 2012-05-12
Hi Experts,

I am facing problem with export to csv on XP pro sp3 machine.
I am exporting data from Sage MMS 200 v7.00.0043 to Excel 2010 as CSV (comma delimited file)
When I export and press save as to CSV it export the data but not showing all the column.

Row data is fine.

Exporting same file from different machine is perfectly fine.

So far I have
Reinstalled Office 2010,
Installed Office 2010 SP1,
Reinstalled Sage 200 MMS and
Installed all OS and other office updates.

But no joy!!!

Please help
0
Comment
Question by:Vijaytyagi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
11 Comments
 
LVL 10

Expert Comment

by:ukerandi
ID: 36572743
its possible to export data as text file, if possible export as text file and open with Excel file and convert to CSV file.
0
 

Author Comment

by:Vijaytyagi
ID: 36572796
Hi ukerandi,

Yes have tried it but date format is not right.

Thank you
0
 
LVL 46

Expert Comment

by:aikimark
ID: 36573410
1. Does the date column exist in the CSV file?

2. What is the format of the data in the date column?
0
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 
LVL 22

Expert Comment

by:rspahitz
ID: 36574509
If you export to CSV and load back into Excel immediately, is everything there?  If so, it's working correctly and maybe it just *looks* like something is missing (or maybe the app loading it is not properly interpreting things.  For example, Excel does not typically export blank columns at the end unless it has a reason to do so; therefore it may appear that data is missing.  For missing data between columns of other data, you'll get consecutive commas showing up to indicate missing data in a specific location.

And you indicated that "date format is not right"
What are you expecting it to be, and is Excel showing that in the cell?
0
 

Author Comment

by:Vijaytyagi
ID: 36579164
Guys,

When I export same file from my PC or any other user PC then I get all 15 columns (all columns got data) but the PC I am having problem with come out only 9 Columns.

About format is not right when I export to text file then convert into excel.


Thank you
0
 
LVL 46

Expert Comment

by:aikimark
ID: 36579345
Are the regional settings for the problem PCs the same as the good PCs?
0
 

Author Comment

by:Vijaytyagi
ID: 36579465
Yes...settings are same..even I have Reinstalled Office 2010 few times with SP1.
0
 
LVL 46

Expert Comment

by:aikimark
ID: 36579526
Is it possible that the columns are hidden, rather than missing?
0
 

Accepted Solution

by:
Vijaytyagi earned 0 total points
ID: 36579709
Thats what I thought but its not the case :-)

Thank you
0
 
LVL 46

Expert Comment

by:aikimark
ID: 36579801
please post the first 10 rows of the data (.CSV) and an example of the same data imported (incorrectly) into Excel (.xlsx).
0
 

Author Closing Comment

by:Vijaytyagi
ID: 36898951
Fixed after reset PC from factory setting.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question