请参阅使用MS Excel（xls / xlsx）使用MDAC和Oledb [ ^ ]。获得Excel数据后，只需将字段与数据库中的字段匹配即可。

i have excel sheet with data i want to import that data to database but the imported excel sheet format is different and database structure is different. how i can import that excel sheet into database.

thank you

What I have tried:

i tired with same format i.e., both excel and database having same format

See Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^]. Once you have the Excel data you just need to match the fields with those of your database.