Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Export to CSV

Posted on 2011-09-20
11
Medium Priority
?
843 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

618 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