OLEDB Parameter Question

[bob]

Hi,
I have a dataset that I want to use to insert records into an empty
Access database table.

The table does not have any indexes or required fields.
It is just a dumping ground enroute to an Excel spreadsheet.

The dataadapter update command fails with
"Parameter ?_6 has no default value"

It appears to be due to one or more fields having a null value or
empty string?

If I reduce the insert statement to a subset of the fields it works.

Given that the target table has no required fields what could be
causing this?
Is there a way around it?

Thanks
Bob

[Nicholas Paldino [.NET/C# MVP]]

Bob,

The reason this is occuring is that you are not defining fields in your
insert query that need to be populated. If the field does not have a
default constraint, then you MUST insert some sort of value for it in your
insert statement.

It has nothing to do with a null value or an empty string.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"bob" <st**************@cutthis.adriley.co.nzwrote in message
news:a8********************************@4ax.com...

Hi,
I have a dataset that I want to use to insert records into an empty
Access database table.

The table does not have any indexes or required fields.
It is just a dumping ground enroute to an Excel spreadsheet.

The dataadapter update command fails with
"Parameter ?_6 has no default value"

It appears to be due to one or more fields having a null value or
empty string?

If I reduce the insert statement to a subset of the fields it works.

Given that the target table has no required fields what could be
causing this?
Is there a way around it?

Thanks
Bob