VStudio 2010 64bit - Best way to transfer xls file to database RRS feed

  • Question

  • I'm new to using databases in Visual Studio.  I have a huge excel spreadsheet that I want to be able to query from my program.  I've tried converting it into an access database then loading it in Visual Studio but keep getting the error:  "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine".  Which is a BS because I went through and upgraded to the new version for 64 bit machines.  So i'm quite frustrated with that approach!!!

    I only have one table that I need to be able to query.  Whats the best way to get access to it in my program? (I'm using visual C#)

    • Moved by Min ZhuModerator Tuesday, September 13, 2011 6:32 AM (From:64-Bit .NET Framework Development.)
    Friday, September 9, 2011 7:53 PM


All replies