Solved

Export All Access Database Tables To Excel File

Posted on 2012-03-12
7
402 Views
Last Modified: 2012-08-14
I need a vb.net code to export all the access database tables to an excel file.

I do not want to used the dataset. because the database file is so huge.

so it is possible to directly export access database tables and its data directly to excel file

Thanks in advance.
0
Comment
Question by:baabaa_nl
  • 3
  • 2
  • 2
7 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37712496
<I do not want to used the dataset. because the database file is so huge.>
Can you clearly explain what you mean by this?

Do you want each table to be it's own sheet?
0
 

Author Comment

by:baabaa_nl
ID: 37713991
hi boag2000,

yes thats right, i need each table to be in its own sheet
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 250 total points
ID: 37714846
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:baabaa_nl
ID: 37717319
Well that was a VBA code. But i am using VB.Net.

Can you please give me the code that is equivalent to VB.net or a code that does the similar function.

Thanks In Advance.
0
 
LVL 83

Assisted Solution

by:CodeCruiser
CodeCruiser earned 250 total points
ID: 37717789
You can put that code in a module in access db and then call it from VB.NET

another approach shown here

http://bytes.com/topic/visual-basic-net/answers/336747-export-access-file-excel-vb-net
0
 

Author Comment

by:baabaa_nl
ID: 37719142
Thank you CodeCruiser, i will try the code from the page you sent me.

Can you please give me the code to call the module in access from vb.net.

Thanks in advance guys.
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 37719572
You would need to do Interop for that. Use Application.Run method on the Access application object.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question