<div>
&lt;I do not want to used the dataset. because the database file is so huge.&gt;<br />
Can you clearly explain what you mean by this?<br />
<br />
Do you want each table to be it's own sheet?
</div>


<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?

<div>
hi boag2000,<br />
<br />
yes thats right, i need each table to be in its own sheet
</div>


hi boag2000,

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

<div>
Well that was a VBA code. But i am using VB.Net.<br />
<br />
Can you please give me the code that is equivalent to VB.net or a code that does the similar function.<br />
<br />
Thanks In Advance.
</div>


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.

<div>
Thank you CodeCruiser, i will try the code from the page you sent me.<br />
<br />
Can you please give me the code to call the module in access from vb.net.<br />
<br />
Thanks in advance guys.
</div>


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.

<div>
You would need to do Interop for that. Use Application.Run method on the Access application object.
</div>


You would need to do Interop for that. Use Application.Run method on the Access application object.

<div>
<div class="content wysiwyg-content">
I need a vb.net code to export all the access database tables to an excel file.<br />
<br />
I do not want to used the dataset. because the database file is so huge.<br />
<br />
so it is possible to directly export access database tables and its data directly to excel file<br />
<br />
Thanks in advance.
</div>
</div>


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.

Export All Access Database Tables To Excel File

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,