Search code examples
winapiodbc32bit-64bittext-driver

Is it possible to read csv file using 32 bit Microsoft text driver in 64 bit application

I have a requirement where i need to import some data from CSV file using Microsoft Text Driver. My development environment is:-

Windows7 64 bit
Office 2007 (32 bit)

when i try to open a connection it gives me error:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Is it possible to read csv file using 32 bit text driver and 64 bit application?

Solution

  • 64-bit processes can't load 32-bit DLLs. You'll have to have a separate 32-bit application that reads the CSV files and stores the data somewhere (e.g., your database).