Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1,560
Default CSV File Opening Conversion Issue

I have a user that when they try to open a CSV file from the desktop or any
other location the file does not open correctly. When the file is opened on
other machines using Excel it opens correctly.

What seems to be happening is in column A we are getting the first 14
characters of the line and in column B we are getting the next 10 characters
and in column C we are getting the rest of the line. The system is not
parsing the record out because we are still seeing the quotes and commas in
the columns.

When we run the text to columns wizard on column C it parses out the record
correctly.

I am not sure what the issue could be that is opening the file in a "fixed
with" method ... because this is happening it seems on all CSV files.

The user tried to reinstall Excel and I personally did a repair on Excel and
the issue is still present.

Any ideas?

David


  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2,646
Default CSV File Opening Conversion Issue

Try to check if in Windows Control panel/International settings/Custom
settings List separator are set different than on the other machines!
Regards,
Stefi


€žDavid€ť ezt Ă*rta:

I have a user that when they try to open a CSV file from the desktop or any
other location the file does not open correctly. When the file is opened on
other machines using Excel it opens correctly.

What seems to be happening is in column A we are getting the first 14
characters of the line and in column B we are getting the next 10 characters
and in column C we are getting the rest of the line. The system is not
parsing the record out because we are still seeing the quotes and commas in
the columns.

When we run the text to columns wizard on column C it parses out the record
correctly.

I am not sure what the issue could be that is opening the file in a "fixed
with" method ... because this is happening it seems on all CSV files.

The user tried to reinstall Excel and I personally did a repair on Excel and
the issue is still present.

Any ideas?

David


Reply
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
Opening File Issue? Ken Excel Discussion (Misc queries) 2 June 1st 09 03:19 PM
How to avoide data conversion when opening a text file? Vel Excel Discussion (Misc queries) 18 April 17th 08 03:57 PM
Opening Excel file issue? Rick S. Excel Discussion (Misc queries) 0 October 10th 07 03:16 PM
File Opening issue jerminski73 Excel Worksheet Functions 0 April 25th 07 03:30 PM
File conversion-text encoding issue elhirsch Excel Discussion (Misc queries) 2 September 11th 06 03:19 PM


All times are GMT +1. The time now is 11:33 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"