Excel 64bit 2016 Database Connection 32bit...what to do?

I'm no expert with this so take it easy on me ;-)

We've got a Pervasive V10 database. Its 32bit.

We've got so much data (over 2 million lines) that we need to start using excel 64bit for some reporting. I installed Excel 64bit and tried connecting to the Database like I've done before on Excel 32bit, but get an error "mismatched". From what I've come to find this is the 64 vs 32bit problem.

I can't seem to find a 64bit Pervasive DB ODBC driver. Would that be all I need? Or is it not physically possible to connect 64bit excel to a 32bit database?

Any help would be appreciated!

Solved it. I was able to get the 64bit ODBC driver from Pervasive 11 client installer. And it worked.

Now I have another problem, but I'll make a new post for that as its different issue.