Importing transactions using csv spreadsheet error

[melsee]

I am using UD,SYMB,TRAN,ANUM,BNUM,CNUM but get the following error: Could not find all the specified fields in the importing file. I have given the columns in the csv spreadsheet the above headings. I also tried with no column headings and get the same error message. I am running Vista and Office 2007.

[Mark]

Hi melsee,

I'd suggest opening your CSV file in Notepad (not Excel), and look at what each line looks like. You can copy/paste a line from your file here if you'd like more help.

It is not necessary (but it doesn't hurt) to have the field names in the header row of your CSV file.

[melsee]

Here is sample of the data file:

1/19/1999,BGAT,BUY,0,470,0
3/7/2002,JMCVX,BUY,17.78998918,202.361,0
3/12/2002,RYLPX,BUY,12.09998861,280.992,0
5/22/2002,RYLPX,BUY,12.46002409,192.616,0
7/10/2002,RYLPX,BUY,10.61997922,131.827,0
7/22/2002,RYLPX,BUY,9.709960845,95.263,0
9/13/2002,RYLPX,BUY,9.719957232,92.593,0
10/22/2002,JMCVX,BUY,14.05007447,35.587,0

[Mark]

Hi melsee,

For data in this format, you would want to use a format string of:

MM/DD/YY,SYMB,TRAN,ANUM,BNUM,CNUM

You were previously using UD instead of MM/DD/YY. The UD key matches on the 6 character date in the format YYMMDD, but your date is in the format of MM/DD/YY, so you would want to use those keys instead.