Put excel to database

when I have to put excel data to datase got error invalid column name but excel column name ane database column name are same. plz gives any suggeation.


@dfd2e18560c138cb7425711f7,

The Database should have exact number of columns with exact names then only this will work.

Try using Bulk Insert

Thanks,
Ashok :slight_smile:

I gives the exact column name but did not work it.

solve the above problem but got the error only one connection can be use plz,
give any solution.

@dfd2e18560c138cb7425711f7,

more details of the error please.


got this error

@dfd2e18560c138cb7425711f7,

Are you establishing more than one connection? The error states that there are more than one connections.

Thanks,
Ashok :slight_smile: