LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
TRR
 
Posts: n/a
Default Multiple columns of data saved in a CSV file appears in a single c

Summary:
The problem is that when I export data from an application to a CSV file and
open it, it is appearing differently on the different PCs which are having
the same versions of Excel (Microsoft Excel 2000 9.0.7924 SP-3).

Issue Description:
On one PC, when the saved .csv file is opened, the data in it is spreading a
record record containing some 4 fields across 4 different cells/columns. This
is fine and is what is required for me.

While on the other PC, when the saved .csv file is opened, the entire record
is inserted into a SINGLE CELL/COLUMN containing those 4 values separated by
a comma. But here as well, I would want a record to spread across different
columns/cells.

Hence I would like to know the answers to any of the below questions:
(1) why is there a difference in the appearance while the Excel versions are
exactly the same?
(2) Is there any option/setting in Excel that is influencing this?
(3) Last but not the least, how do I fix it?

Hope you guys have a solution to this. Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to Synchronize data frm svrl workbooks & columns to 1 workbo jbsand1001 Excel Discussion (Misc queries) 1 April 28th 05 10:42 AM
File Error: Data May Have Been Lost Tbird2340 Excel Discussion (Misc queries) 8 March 20th 05 05:31 PM
Matching data in multiple columns BuddyB Excel Discussion (Misc queries) 1 February 27th 05 08:05 PM
Importing .txt data files increases .xls file size BrianJ Excel Discussion (Misc queries) 1 January 29th 05 02:02 PM
Lookup Data in Several Columns simplywitt Excel Worksheet Functions 4 November 24th 04 04:11 PM


All times are GMT +1. The time now is 10:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"