Blue Prism Product

There are two interfaces to choose for different versions of Excel (xls,xlsx,csv): Microsoft.Jet.OLEDB.4.0 and Microsoft.Ace.OLEDB.12.0

The Jet can access Microsoft Office 97-2003, but you cannot Access 2007 whereas ACE is a database connectivity component which in addition also allows connectivity to Excel.

Thanks,
Rajath G

There are two interfaces to choose for different versions of Excel (xls,xlsx,csv): Microsoft.Jet.OLEDB.4.0 and Microsoft.Ace.OLEDB.12.0

The Jet can access Microsoft Office 97-2003, but you cannot Access 2007 whereas ACE is a database connectivity component which in addition also allows connectivity to Excel.

Thanks,
Rajath G

There are two interfaces to choose for different versions of Excel (xls,xlsx,csv): Microsoft.Jet.OLEDB.4.0 and Microsoft.Ace.OLEDB.12.0

The Jet can access Microsoft Office 97-2003, but you cannot Access 2007 whereas ACE is a database connectivity component which in addition also allows connectivity to Excel.

Thanks,
Rajath G

There are two interfaces to choose for different versions of Excel (xls,xlsx,csv): Microsoft.Jet.OLEDB.4.0 and Microsoft.Ace.OLEDB.12.0

The Jet can access Microsoft Office 97-2003, but you cannot Access 2007 whereas ACE is a database connectivity component which in addition also allows connectivity to Excel.

Thanks,
Rajath G

There are two interfaces to choose for different versions of Excel (xls,xlsx,csv): Microsoft.Jet.OLEDB.4.0 and Microsoft.Ace.OLEDB.12.0

The Jet can access Microsoft Office 97-2003, but you cannot Access 2007 whereas ACE is a database connectivity component which in addition also allows connectivity to Excel.

Thanks,
Rajath G

There are two interfaces to choose for different versions of Excel (xls,xlsx,csv): Microsoft.Jet.OLEDB.4.0 and Microsoft.Ace.OLEDB.12.0

The Jet can access Microsoft Office 97-2003, but you cannot Access 2007 whereas ACE is a database connectivity component which in addition also allows connectivity to Excel.

Thanks,
Rajath G

1. There's a NewLine just before Extended Properties. I've no idea if that could cause the problem here.
2. There's a semicolon ; at the end of the string, but I would think there shouldn't be one at the end since it is used to delimit/separate elements in the string.
3. There's no single quote after Excel 12.0 Xml.

Hi Dave,
I think you are correct.  I put your string in and that error went away.  It now gives the following registration error.  I see a few different threads with numerous different ideas on what may cause this error.  Did you encounter this when starting out?

Could not execute code stage because exception thrown by code stage: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Thanks,

Jon

1. There's a NewLine just before Extended Properties. I've no idea if that could cause the problem here.
2. There's a semicolon ; at the end of the string, but I would think there shouldn't be one at the end since it is used to delimit/separate elements in the string.
3. There's no single quote after Excel 12.0 Xml.

https://www.microsoft.com/en-us/download/details.aspx?id=54920

Hi Dave,
I think you are correct.  I put your string in and that error went away.  It now gives the following registration error.  I see a few different threads with numerous different ideas on what may cause this error.  Did you encounter this when starting out?

Could not execute code stage because exception thrown by code stage: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Thanks,

Jon

1. There's a NewLine just before Extended Properties. I've no idea if that could cause the problem here.
2. There's a semicolon ; at the end of the string, but I would think there shouldn't be one at the end since it is used to delimit/separate elements in the string.
3. There's no single quote after Excel 12.0 Xml.

Hi Dave,
I've been reading that the 32 bit version is needed instead of the 64.  Are you saying that is the same issue you ran into?  If so do you happen to have a link to the 32 bit version needed?  I've created a ticket with my IT and will hopefully be able to verify a thumbs up or down shortly on if this is the problem.

Thanks,

Jon

https://www.microsoft.com/en-us/download/details.aspx?id=54920

Hi Dave,
I think you are correct.  I put your string in and that error went away.  It now gives the following registration error.  I see a few different threads with numerous different ideas on what may cause this error.  Did you encounter this when starting out?

Could not execute code stage because exception thrown by code stage: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Thanks,

Jon

1. There's a NewLine just before Extended Properties. I've no idea if that could cause the problem here.
2. There's a semicolon ; at the end of the string, but I would think there shouldn't be one at the end since it is used to delimit/separate elements in the string.
3. There's no single quote after Excel 12.0 Xml.

Hi Dave,
I've been reading that the 32 bit version is needed instead of the 64.  Are you saying that is the same issue you ran into?  If so do you happen to have a link to the 32 bit version needed?  I've created a ticket with my IT and will hopefully be able to verify a thumbs up or down shortly on if this is the problem.

Thanks,

Jon

https://www.microsoft.com/en-us/download/details.aspx?id=54920

Hi Dave,
I think you are correct.  I put your string in and that error went away.  It now gives the following registration error.  I see a few different threads with numerous different ideas on what may cause this error.  Did you encounter this when starting out?

Could not execute code stage because exception thrown by code stage: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Thanks,

Jon

1. There's a NewLine just before Extended Properties. I've no idea if that could cause the problem here.
2. There's a semicolon ; at the end of the string, but I would think there shouldn't be one at the end since it is used to delimit/separate elements in the string.
3. There's no single quote after Excel 12.0 Xml.

Hi Dave,
I've been reading that the 32 bit version is needed instead of the 64.  Are you saying that is the same issue you ran into?  If so do you happen to have a link to the 32 bit version needed?  I've created a ticket with my IT and will hopefully be able to verify a thumbs up or down shortly on if this is the problem.

Thanks,

Jon

https://www.microsoft.com/en-us/download/details.aspx?id=54920

Hi Dave,
I think you are correct.  I put your string in and that error went away.  It now gives the following registration error.  I see a few different threads with numerous different ideas on what may cause this error.  Did you encounter this when starting out?

Could not execute code stage because exception thrown by code stage: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Thanks,

Jon

1. There's a NewLine just before Extended Properties. I've no idea if that could cause the problem here.
2. There's a semicolon ; at the end of the string, but I would think there shouldn't be one at the end since it is used to delimit/separate elements in the string.
3. There's no single quote after Excel 12.0 Xml.

Hi Dave,
I've been reading that the 32 bit version is needed instead of the 64.  Are you saying that is the same issue you ran into?  If so do you happen to have a link to the 32 bit version needed?  I've created a ticket with my IT and will hopefully be able to verify a thumbs up or down shortly on if this is the problem.

Thanks,

Jon

https://www.microsoft.com/en-us/download/details.aspx?id=54920

Hi Dave,
I think you are correct.  I put your string in and that error went away.  It now gives the following registration error.  I see a few different threads with numerous different ideas on what may cause this error.  Did you encounter this when starting out?

Could not execute code stage because exception thrown by code stage: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Thanks,

Jon

1. There's a NewLine just before Extended Properties. I've no idea if that could cause the problem here.
2. There's a semicolon ; at the end of the string, but I would think there shouldn't be one at the end since it is used to delimit/separate elements in the string.
3. There's no single quote after Excel 12.0 Xml.

Hi Dave,
I've been reading that the 32 bit version is needed instead of the 64.  Are you saying that is the same issue you ran into?  If so do you happen to have a link to the 32 bit version needed?  I've created a ticket with my IT and will hopefully be able to verify a thumbs up or down shortly on if this is the problem.

Thanks,

Jon

https://www.microsoft.com/en-us/download/details.aspx?id=54920

Hi Dave,
I think you are correct.  I put your string in and that error went away.  It now gives the following registration error.  I see a few different threads with numerous different ideas on what may cause this error.  Did you encounter this when starting out?

Could not execute code stage because exception thrown by code stage: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Thanks,

Jon

1. There's a NewLine just before Extended Properties. I've no idea if that could cause the problem here.
2. There's a semicolon ; at the end of the string, but I would think there shouldn't be one at the end since it is used to delimit/separate elements in the string.
3. There's no single quote after Excel 12.0 Xml.

Hi Dave,
I've been reading that the 32 bit version is needed instead of the 64.  Are you saying that is the same issue you ran into?  If so do you happen to have a link to the 32 bit version needed?  I've created a ticket with my IT and will hopefully be able to verify a thumbs up or down shortly on if this is the problem.

Thanks,

Jon

https://www.microsoft.com/en-us/download/details.aspx?id=54920

Hi Dave,
I think you are correct.  I put your string in and that error went away.  It now gives the following registration error.  I see a few different threads with numerous different ideas on what may cause this error.  Did you encounter this when starting out?

Could not execute code stage because exception thrown by code stage: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Thanks,

Jon

1. There's a NewLine just before Extended Properties. I've no idea if that could cause the problem here.
2. There's a semicolon ; at the end of the string, but I would think there shouldn't be one at the end since it is used to delimit/separate elements in the string.
3. There's no single quote after Excel 12.0 Xml.