By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,279 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Excel to Access

P: 3
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 ;) )
Expand|Select|Wrap|Line Numbers
  1. oleDbAdaptExcel(select * from Sheet)
  2. oleDbAdaptAccess(select * from Table)
  3. oleDbAdaptExcel.fill(dataset)
  4. oleDbAccess.update(dataset)
  5.  
Many thanks for your help, i'm a bit confused!
Apr 12 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.