Excel to Access

[mazelx]

Hi there,

I'm searching a way to export Excel data to access...

So i thought to do like this :

Excel -> Dataset -> Access

Is that the best way to do it? I have big excel files (multi-sheets, and up to 5000 rows), so it doesn't have to be too time-consuming...

If that method is correct, how could do it in vb.net?

here's the way I imagine it (simplified way ;) )

oleDbAdaptExcel(select * from Sheet)
oleDbAdaptAccess(select * from Table)
oleDbAdaptExcel.fill(dataset)
oleDbAccess.update(dataset)
 

Many thanks for your help, i'm a bit confused!