Thank you for all your replies.  The DTS did not export all the data over to Access database because there was too much extra white space at the end of the data...