Quote Originally Posted by heavenlynights View Post
I am also having an issue importing the attributes.txt file into excel. too many columns. does anyone have a resolution for this problem.
TIA
I'm a wiz at forcing Excel to behave, so if the tips below don't work feel free to IM me if you're stuck.

It's probably the way you are importing. During the Data import choose "Delimited" instead of fixed-width and on the next tab select "Tab" as your delimiter and de-select all others. If you have tab AND comma or something like that it will be too many cols, but just tabs should come in fine.

if you're trying to get a difficult file to convert in Excel, sometimes this works:

1) open the file in winword (or ultraedit or some other good text editor)
2) edit/replace tab (^t in winword) with ~ or % or $ or some char that isn't in your data file. Don't use the winldcards (* or ?)
3) save the file. Open it in excel. During the convert choose the char you replaced the tabs with as your delimiter.