Homepage of programmer Torben Warberg Rohde

Reading CSV files on 64 bit Windows Server

In the olden days I used the Jet-provider with a schema.ini to read CSV-files.

Yesterday - after having just finished a small console app on our 32 bit developer box - I deployed it to our 64 bit production server..... crash.... "provider not found".

After a fair amount of digging I downloaded one the many homemade CSV readers... Turns out it was written by an American, so there was no way to specify the charset of the file ;-)

Then I found the "Microsoft Access Database Engine 2010 Redistributable" package (read this small note on how to specify the connection string).
It's a bit bloated just for reading a CSV file, but it installed in a few minutes, did not require restarting the server, and it works perfectly.