I am running Microsoft Excel 2010, and I cannot get my data into the Excel Workbook.

Download the following Microsoft Hotfix for Excel 2010.

https://support.microsoft.com/en-us/kb/2405840