The error "The provider could not determine the Double value. For example the row was just created, the default for the Double column was not available, and the consumer had not set a new Double value." is thrown when you test some SQL for an import query when adding a data source.
The issue was trying to append different datatypes together. The must be explicitly cast to, for instance, the string datatype for this to work.
select [Region Desc]+'-'+[Country Code]+'-'+'Order#: '+[Purchase Order Num] as [Lease Agreement],* from [Report$]
select [Region Desc]+'-'+[Country Code]+'-'+'Order#: '+STR([Purchase Order Num]) as [Lease Agreement],* from [Report$]
Imported Document Id
This is machine translated content
Login to Subscribe
Please login to set up your
For security reasons, your link to this document has expired. Please click on the attachment link to access this file.
The attachment that you are looking for no longer exists.
There has been an issue retrieving your attachment. Please try again.
Currently server is down.
Didn't find the article you were looking for? Try these resources.