Load CSV file to a database in Windows 64bit
-
I have a csv file. I want to load the csv fil to a database. I tried by using CDAOSatabase instance with 'Microsoft Text Writer' jet enine. ( One Problem I found that when I execute a query to ceate a new table, the file equivalent to the new table is created in physical disk, even though I didn't commit the transaction) Also I heard that in windows there will not be a 64bit 'Microsoft Text Writer' in winows 64 bit. ( In my spec there is no MSOffice installed separately on this winows 64 bit machine ) Could ou please let me know is there any solution to use 'Microsoft Text Writer' in Windows64 bit machine without Microsoft office installed.
aks
-
I have a csv file. I want to load the csv fil to a database. I tried by using CDAOSatabase instance with 'Microsoft Text Writer' jet enine. ( One Problem I found that when I execute a query to ceate a new table, the file equivalent to the new table is created in physical disk, even though I didn't commit the transaction) Also I heard that in windows there will not be a 64bit 'Microsoft Text Writer' in winows 64 bit. ( In my spec there is no MSOffice installed separately on this winows 64 bit machine ) Could ou please let me know is there any solution to use 'Microsoft Text Writer' in Windows64 bit machine without Microsoft office installed.
aks
You can install the Microsoft Access Database Engine 2010 Redistributable[^]. I'm not sure if the Text Writer is included but I think so. There are 32 and 64 bit versions of the redistributable. The version to be installed depends on the application that will use the database drivers (install the 32 bit version for a 32 bit application even when it is running on a 64 bit Windows). Special care must be taken when Office is installed (see the CP tip Microsoft Access Database Engine 2010 Redistributable[^]).