IMPORT ERRORS

[leo]

When I import an xlss, I get errors on some rows. I think this is because the
data type is listed as "double" not "text" like the other fields. I can't
figure out how to change "double" to "text". I've tried edit copy paste
special formulas in the xlss field and then import but that does not work.

How do change the data type when importing an xlss?

thx

 

[Jeff C]

Create an import specification. After you have created and saved it, go back
in and modify the datatype for the questionable fields on the first page of
that import spec

 

[leo]

How do i do that?

Also, the original file has about 15,000 rows but the imported file has
18,000. Why would xs add 3,000 lines?

After importing it gived me 2 files, the original file and an error file. Is
the data in the original file accurate?

thx