Bulk import into sql sever from 32 bit xlsx

SSIS and Import/Export
1

Unfortunately, I have excel installed that is 32 bit. Because of this it has made it difficult to use Bulk sql statement to import the excel data into it.

Does anyone have a working SQL code that can import 32 bit excel data into a 64 bit database ?

Please advise.
Thanks

2

You need to install the 64-bit driver. There is a trick to this...see this: https://datasavvy.me/2017/07/20/installing-the-microsoft-ace-oledb-12-0-provider-for-both-64-bit-and-32-bit-processing/

3

Thank you for the information !