Export multiple excel sheets into Access using vb.net

See more:

VB

I have searching this in Google for a week, not able to figure out.

Here is the scenario.

I have multiple worksheets, in that few columns exist in few sheets. I would like to merge all worksheets and export into single access table using vb.net or C#.

So far, below code works perfectly for single worksheet.

_command.CommandText = "SELECT * INTO [" & dbpath & "].[Sheet1] FROM [Sheet1$]"

1. For me Sheets are unknown, above works for one sheets.
2. Few columns existed in few sheets, like Firstname in sheet1, sheet4 ... etc. So that case i need to add both data under Firstname.

Any ideas.