The file I am looking to import is massive and its row capacity exceeds Excel otherwise I would reformat it for Access in Excel. I do have the Microsoft Scripting Run Time enabled. My Access version ...

Visual Basic for Applications (VBA) is used to write programs for Microsoft Office (MS Office, Office) applications, including Access, Excel, PowerPoint, Publisher, Word, and Visio.