Error appending SQL table with Iman (2 replies)
Sue, this is due to the comma in the value.
In a map transform prior to the DBWrite either:
- Apply the following formula:
Format(%DepletionAllowance, "0.00")
Format(%DepletionAllowance, "0.00")
- Or change the field type to text.
This behaviour has been improved for the forthcoming version.
THANK YOU for getting back to me so quickly. That worked perfectly! What a relief! Thanks!
I am starting with an excel sheet and attempting to append the records to a sql table. I've verified that my field names match sql exactly and I've set the field types to be the same as sql. When I tell it to insert the records, it gets to record #12 -- the first one with an actual value rather than a 0 in a column and it blows up with an error: there are fewer columns in the insert statement than values specified in the values clause. I'm starting to wonder if it's the comma formatting of the number that is causing the issue, but I've taken all formatting out of excel and I've used a formatnumber() function to set the field to 3 decimals. Not sure what else to do. Please see the snapshots, I think they will make more sense.
I know this should work because I can easily upload the records using an append query in microsoft access, but I'd prefer to use Iman and give the client an easy way to upload. I'd prefer to keep them away from an access update - that sounds very dangerous for them. =) Thanks!