Hi,
Just do the following steps to successfully read or write rows using SSIS excel Source / Destination on 64bit system.
1. Download booth 64bit and 32bit version of Microsoft Access Database Engine (although this sounds strange - its include drivers for xlsx files)
Link: http://www.microsoft.com/en-us/download/details.aspx?id=13255
2. run the downloaded files from the run box (ctrl+r) and add "/passive" at the command.
for example: AccessDatabaseEngine.exe /passive
run this command for the 64bit version and the 32bit version of the file.
3. in the connection manager to excel change the connection string from
Provider=Microsoft.JET.OLEDB.4.0
to
Provider=Microsoft.ACE.OLEDB.12.0;
leave the rest as it is.
You can verify that the specific excel file version is correct at the end of the connection string.
8.0 stands for excel 97-2003
Good Luck
if something goes wrong please let me know...
Yochanan
Just do the following steps to successfully read or write rows using SSIS excel Source / Destination on 64bit system.
1. Download booth 64bit and 32bit version of Microsoft Access Database Engine (although this sounds strange - its include drivers for xlsx files)
Link: http://www.microsoft.com/en-us/download/details.aspx?id=13255
2. run the downloaded files from the run box (ctrl+r) and add "/passive" at the command.
for example: AccessDatabaseEngine.exe /passive
run this command for the 64bit version and the 32bit version of the file.
3. in the connection manager to excel change the connection string from
Provider=Microsoft.JET.OLEDB.4.0
to
Provider=Microsoft.ACE.OLEDB.12.0;
leave the rest as it is.
You can verify that the specific excel file version is correct at the end of the connection string.
8.0 stands for excel 97-2003
Good Luck
if something goes wrong please let me know...
Yochanan
אין תגובות:
הוסף רשומת תגובה