Maybe cast to date will help:

select cast(getdate() as date)

I think you're correct - you need to use the 32 bit runtime in order to import xls files. During testing this can be set in Visual Studio under...