I am not able to import forecasts.  I have tried the following:
In excel, save as *.prn and import as fixed length
In excel, save as *.csv and import as comma delimited
In excel date field, I tried custom format with YYYMMDD and it displays as an infinite number of ###### signs.  If I format the cells as text, they display correctly as 20041122.
The screen that goes unexplained in this process is the bottom half of the MR-A Import Forecast Data Window.  This has 2 fields to the left of each label (Item Number, Date, Qty), to which there is no explanation of what info is needed.  It will not let you enter 0 for the date, so I tried 8 in the left field for the number of integers, and left the others at 0.  Also tried the item number at 15 for the integers in the item number field of the import file, and 3 for the greatest number of integers for Qty.
There are 2 other wild cards that may contribute to the problem.  My import file contains repeats of the items with different dates (weekly).  And the item numbers have a hyphen in the middle.
Does anybody know what I am missing?
Thanks.

Tim,
 
Thank you very much.  It worked like a charm.  Where I was lost is not knowing to put in the column numbers.
 
Steve