Trying to import data from an excel spreadsheet to my SQL database
Windows 2008 64 Bit Server
Windows 7 64 Bit
Office 2010 64 Bit
I have a spreadsheet with 2647 rows that was created by doing a dir command of my folders on my file system. The File was created as a name.csv file I edited the name.csv file then saved it as name.xlsx file.
When trying to import using MSSMS I get the following error
the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine