Requires Data Sync Release : 3.0.908+
Previously the Excel Data Sync provider was based on the Microsoft Excel Driver for OleDB this was Jet for XLS under 32 bit and ACE12 for XLSX or 64 bit. This had many issues the main issue being 32 and 64 bit support problems. This accounted for a good proportion of the HelpDesk Tickets.
Now we have a new provider for Excel the OpenXML Excel Provider and as the name suggests this is based on the OpenXML SDK.
This provider also supports DELETE Operations which is nice, not much more to say really simply connect to an Excel Sheet and go.