Hello forum,
I am writing an Access VBA code module, which imports SAP actual data into an Access table.
I believe all the proper libraries have been tagged under VBA references.
I am using SAP GUI scripting code as well, to navigate thru the SAP screens.
The code works good for pulling any text values. But for pulling amounts, which in this case are dollars, the code breaks.
For the following line of code:
rsSAPActuals!Dollars = GridView.GetCellValue(i, "WTGBTR")
the code breaks with the following error noted:
"Error 3421 Data type conversion error"
The odd thing is, the Access table field, using a decimaled number format does get many correct dollar amounts, but the full table never gets all the records from SAP. It is truncated.
Would anyone know what my problem is? Is in my code?
Thank you in advance for any help here!
I am writing an Access VBA code module, which imports SAP actual data into an Access table.
I believe all the proper libraries have been tagged under VBA references.
I am using SAP GUI scripting code as well, to navigate thru the SAP screens.
The code works good for pulling any text values. But for pulling amounts, which in this case are dollars, the code breaks.
For the following line of code:
rsSAPActuals!Dollars = GridView.GetCellValue(i, "WTGBTR")
the code breaks with the following error noted:
"Error 3421 Data type conversion error"
The odd thing is, the Access table field, using a decimaled number format does get many correct dollar amounts, but the full table never gets all the records from SAP. It is truncated.
Would anyone know what my problem is? Is in my code?
Thank you in advance for any help here!