Importing CSV files
 

Normally when you click on a csv file excel opens it witout problem. However
I have one user who when they click on the csv file finds that it open in an
unformatted state. In order to open the file properly she has to go through
the import process and place a tick in the comma section. When this is done
all the data is formatted correctly. I am able to open this file without
problem on my machine.

In order to try and fix this I uninstalled and reinstalled office. I also
tried doing it under another profile on the same machine to see if it was a
profile problem. It also failed.

Any ideas on what I can do to solve this?

It is possibly a problem with the registration of .CSV files.

Open any folder:

Tools Folder Options... File Types

Then carefully compare the .CSV registration information on a machine that
works correctly with one that does not.

Good Luck
--
Gary's Student


"Chris" wrote:

Normally when you click on a csv file excel opens it witout problem. However
I have one user who when they click on the csv file finds that it open in an
unformatted state. In order to open the file properly she has to go through
the import process and place a tick in the comma section. When this is done
all the data is formatted correctly. I am able to open this file without
problem on my machine.

In order to try and fix this I uninstalled and reinstalled office. I also
tried doing it under another profile on the same machine to see if it was a
profile problem. It also failed.

Any ideas on what I can do to solve this?

Thanks Gary I had already looked at that. They are the same on both
machines. Excel opens when she clicks on the csv it just doesnt import
properly so you see all the fields separated by commas rather than being
placed into appropiate columns.

"Gary's Student" wrote:

It is possibly a problem with the registration of .CSV files.

Open any folder:

Tools Folder Options... File Types

Then carefully compare the .CSV registration information on a machine that
works correctly with one that does not.

Good Luck
--
Gary's Student


"Chris" wrote:

Normally when you click on a csv file excel opens it witout problem. However
I have one user who when they click on the csv file finds that it open in an
unformatted state. In order to open the file properly she has to go through
the import process and place a tick in the comma section. When this is done
all the data is formatted correctly. I am able to open this file without
problem on my machine.

In order to try and fix this I uninstalled and reinstalled office. I also
tried doing it under another profile on the same machine to see if it was a
profile problem. It also failed.

Any ideas on what I can do to solve this?

I'd check under Control Panel, Regional Settings, Customize, Numbers to see
what the List Separator is. It sounds as if it is not a comma. Just a
guess.

--
Jim
"Chris" wrote in message
...
| Thanks Gary I had already looked at that. They are the same on both
| machines. Excel opens when she clicks on the csv it just doesnt import
| properly so you see all the fields separated by commas rather than being
| placed into appropiate columns.
|
| "Gary's Student" wrote:
|
| It is possibly a problem with the registration of .CSV files.
|
| Open any folder:
|
| Tools Folder Options... File Types
|
| Then carefully compare the .CSV registration information on a machine
that
| works correctly with one that does not.
|
| Good Luck
| --
| Gary's Student
|
|
| "Chris" wrote:
|
| Normally when you click on a csv file excel opens it witout problem.
However
| I have one user who when they click on the csv file finds that it open
in an
| unformatted state. In order to open the file properly she has to go
through
| the import process and place a tick in the comma section. When this
is done
| all the data is formatted correctly. I am able to open this file
without
| problem on my machine.
|
| In order to try and fix this I uninstalled and reinstalled office. I
also
| tried doing it under another profile on the same machine to see if it
was a
| profile problem. It also failed.
|
| Any ideas on what I can do to solve this?

You were spot on thankyou very much

"Jim Rech" wrote:

I'd check under Control Panel, Regional Settings, Customize, Numbers to see
what the List Separator is. It sounds as if it is not a comma. Just a
guess.

--
Jim
"Chris" wrote in message
...
| Thanks Gary I had already looked at that. They are the same on both
| machines. Excel opens when she clicks on the csv it just doesnt import
| properly so you see all the fields separated by commas rather than being
| placed into appropiate columns.
|
| "Gary's Student" wrote:
|
| It is possibly a problem with the registration of .CSV files.
|
| Open any folder:
|
| Tools Folder Options... File Types
|
| Then carefully compare the .CSV registration information on a machine
that
| works correctly with one that does not.
|
| Good Luck
| --
| Gary's Student
|
|
| "Chris" wrote:
|
| Normally when you click on a csv file excel opens it witout problem.
However
| I have one user who when they click on the csv file finds that it open
in an
| unformatted state. In order to open the file properly she has to go
through
| the import process and place a tick in the comma section. When this
is done
| all the data is formatted correctly. I am able to open this file
without
| problem on my machine.
|
| In order to try and fix this I uninstalled and reinstalled office. I
also
| tried doing it under another profile on the same machine to see if it
was a
| profile problem. It also failed.
|
| Any ideas on what I can do to solve this?