Solved

Export to CSV

Posted on 2011-09-20
11
794 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
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 45

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
 
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
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 45

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 45

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 45

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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Suggested Solutions

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
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.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

758 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now