I am using a .csv file to import data into another program. I got an error
on line #??. However, when I open the file and check the entries that did
import, I can see no difference. So I created a new workbook and pasted the
entries there. Saved the file in .csv and then they import. I also took the
entries that originally import and pasted them into the new workbook/
worksheet and that imports fine. I remember or think I do there is a way to
strip the file by opening up a Cleon workbook and inserting the file and for
some reason think I should put an X in the first cell A1. Not sure if this
is correct or where I remember it from. Can anybody tell me why or what to
do. When I export the data originally from the program, I have to export to
a .csv file. That is the only format it will export and import from.

It appear there was an invisible (special charater) that some how got into
the data. You shouldn't have to put anything in "A1" to prevent errors from
occuring. Some data format do put an identifying character(s) at the
beginning of a file, but that doesn't appear to be needed for yhour data
transfers.

What I do do remove special character from data that is being transfered is
I use Notepad. Often I find when transfereing data between different prorams
that special characters cause problems. By pasting the file into Notepad the
special characters are removed. Then I do a second copy from Notepad and
then paste the data into the 2nd application many of my problems are solved.

"klafert" wrote:

I am using a .csv file to import data into another program. I got an error
on line #??. However, when I open the file and check the entries that did
import, I can see no difference. So I created a new workbook and pasted the
entries there. Saved the file in .csv and then they import. I also took the
entries that originally import and pasted them into the new workbook/
worksheet and that imports fine. I remember or think I do there is a way to
strip the file by opening up a Cleon workbook and inserting the file and for
some reason think I should put an X in the first cell A1. Not sure if this
is correct or where I remember it from. Can anybody tell me why or what to
do. When I export the data originally from the program, I have to export to
a .csv file. That is the only format it will export and import from.