I am having trouble importing exchange 5.5 sp3 tracking logs to access/excel. I realize the logs are tab delimited and select the appropriate button.
What happens is the recepient's name (which should be column 13) appears as a new record. This makes it impossible to utilize the logs. This field is separated from the previous one by a line feed (according to M$), but I can't figure out how to get it to ignore this. During the import you can see a preview of the data you are importing and no matter what I've tried I can't get it formatted properly. I have searched M$ site and can't find much help on this, they simply tell you to import the log as tab delimited.
I am using Access 2000 with NT 4 SP 5. Any ideas?