How to insert data in ms access

[ashishmani (ashish mani tripathi)]

[Palaniyappan (Palaniyappan P)]

HI
is all the column in your access file is of type string or text
kindly check once the datatype of the column and assign the type here accordingly

Cheers @ashishmani

[ashishmani (ashish mani tripathi)]

[Palaniyappan (Palaniyappan P)]

but the error shows like the datatype mismatch

Cheers @ashishmani

[ashishmani (ashish mani tripathi)]

@Palaniyappan I change id to number, and others column to long text after that this error is come

[Palaniyappan (Palaniyappan P)]

Kindly have a view on this

MS Access Error while inserting data into database from UiPath

I have tried that didn’t work. But now one new thing come up. I tried execute non-query, it is inserting data into database but giving error as well. Once I run my code, it does create an entry in database of ms access that I can see, but gives me error saying " Message box: Object reference not set to an instance of an object." See attachment below. Any suggestion would help. [image]

Cheers @ashishmani

[ashishmani (ashish mani tripathi)]

@Palaniyappan same logic i apply, i can share my xaml

[ashishmani (ashish mani tripathi)]

@Palaniyappan thanku for your helo, i got my mistake…

[Palaniyappan (Palaniyappan P)]

Thats great
@ashishmani