Jeff Johnson wrote on 2014-11-17: >> >> You need to use the right driver on 2010 vs the older one for earlier >> versions. >> >> Provider=Microsoft.ACE.OLEDB.12.0;Data Source= >> c:\myFolder\myExcel2007file.xlsx; >> Extended Properties="Excel 12.0 Xml;HDR=YES"; >> >> Okay, the above works fine on my machine. The only thing is, it pops up >> and asks for a DNS. I select Excel and it works fine. I installed the >> update on my customer and it popped up asking for a DNS and I couldn't >> find one on their machine. Where would the above driver be installed on >> the computer and why does the above command not work? Do I need to >> install something? > >
Jeff, Is the customers machine a 64-bit OS? Is your machine a 32-bit OS? Tracy Pearson PowerChurch Software _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
