M
Mark
I'm writing from memory so I may have some syntax incorrect.
I'm executing sql statements in VBA along the lines of:
strSQL = "Insert Into myTable Values (rst!text1, rst!number1, ....)"
execute strSQL
On a number of records in the recordset, blanks or nulls values are in the
rst!number1 field, which of course is defined as a decimal in myTable.
VBA returns a syntax error.
Is there anyway to these "stuff" blank or null values into a field defined
as decimal?
See, the record set is from a large database and I really don't want to
check data types, but rather want to pass it to the new table (myTable) with
out messing with what is there.
Thank you,
Mark
I'm executing sql statements in VBA along the lines of:
strSQL = "Insert Into myTable Values (rst!text1, rst!number1, ....)"
execute strSQL
On a number of records in the recordset, blanks or nulls values are in the
rst!number1 field, which of course is defined as a decimal in myTable.
VBA returns a syntax error.
Is there anyway to these "stuff" blank or null values into a field defined
as decimal?
See, the record set is from a large database and I really don't want to
check data types, but rather want to pass it to the new table (myTable) with
out messing with what is there.
Thank you,
Mark