How to export .mdb file (it is in folder) to excel file?

Question

3.00/5 (1 vote)

See more:

I want to export data from the .mdb file which is in my folder to excel file in c#,
how to do this anyone help me with piece of code.
thanx in advance
sushil

What I have tried:

I tried using file copy(".mdb", "excel"), but it is not correct i think,
so is there any good way to do this,

also i search on google but most of solution are directly using database connection,
but in my case .mdb file is in folder.

Note: Here i am creating excel file programmatically.

plz hel me.

Posted 18-Jul-16 2:08am

Member 11859517

Updated 18-Jul-16 2:27am

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

NagaNimesh 11474558 · Accepted Answer · 2016-07-18T02:27:00

Solution 2

C# Export Table to Excel - Stack Overflow[^]

At first read all the tables in .mdb to a dataset then refer above link .Hope u understand :)

Posted 18-Jul-16 2:27am

NagaNimesh 11474558

Updated 18-Jul-16 2:30am

v2

Comments

Member 11859517 18-Jul-16 8:51am

thanks NagaNimesh,
how to fill dataset my mdb file is in folder, befor i tried like this also,
do u know how to do this?

NagaNimesh 11474558 18-Jul-16 8:55am

yes,put your code what u had tried i will help u

NagaNimesh 11474558 18-Jul-16 8:58am

http://sizious.com/2015/05/11/how-to-load-an-access-database-into-a-dataset-object-in-c/

Member 11859517 18-Jul-16 9:02am

string source = @"D:\SushilBhat\Development\SCADA Copying file\SCADA\CustomerData.mdb";

DataSet dataset = new DataSet();

dataset.DataSetName = System.IO.Path.GetFileNameWithoutExtension(source);

here i am getting Table count 0;

NagaNimesh 11474558 18-Jul-16 9:11am

System.IO.Path.GetFileNameWithoutExtension(source) will return only the name like CustomerData here you did not extract the tables in mdb file.
System.IO.Path.GetFileNameWithoutExtension means will ge the file name like CustomerData ant not with extension like .mdb.understand??

NagaNimesh 11474558 18-Jul-16 9:15am

here dataset.datasetname means u r fetching the name from input source path by using GetFileNameWithoutExtension method

NagaNimesh 11474558 18-Jul-16 9:12am

refer this link
http://sizious.com/2015/05/11/how-to-load-an-access-database-into-a-dataset-object-in-c/

Member 11859517 19-Jul-16 0:40am

thank NagaNimesh, its working fine but only data are displaying not the column name in my excel.
I am creating excel sheet programmatically, is something missing while creating the excel.

NagaNimesh 11474558 19-Jul-16 0:48am

while reading each table takeout the column names in to an array string then after creating new excel your first append those headders string array then data

NagaNimesh 11474558 19-Jul-16 0:49am

string[] columnNames = dt.Columns.Cast<datacolumn>()
.Select(x => x.ColumnName)
.ToArray();

Member 11859517 19-Jul-16 2:02am

thanks, its working fine.

And I have more table in .mdb file i want each table in separate tab(sheet) is it possible. how to do this do u know?
thanks again.

NagaNimesh 11474558 19-Jul-16 3:10am

plz refer this link
http://www.c-sharpcorner.com/blogs/generate-excel-with-multiple-sheet-from-dataset1

Member 11859517 19-Jul-16 8:47am

thank you NagaNimesh,

NagaNimesh 11474558 19-Jul-16 8:54am

pleasure is mine :) is everything done??

Member 11859517 20-Jul-16 1:40am

yes, everything is don properly, thanks for ur help,

but my doubt is about string connString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};User Id=Admin;Password=",
its working, but i copied same program into another project i got error is
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
why it is happening???, can u clear my doubt.
and why we are using OLEDB connection???

NagaNimesh 11474558 20-Jul-16 5:54am

for ms access database we need to use oledb connection only and after 2007 msaccess the extension is .accdb but before 2007 ms office means 2003 ms office the extension is .mdb for that we need to provide the provider like Microsoft.ACE.OLED.12.0 and some extension i thing plase make sure ur office will able to provide for this OLEDB.12.0 . I too dont know bt im expecting this..

Member 11859517 20-Jul-16 6:20am

thanks NagaNimes for your clarification.
for this i need to installed MS access database engine 2007, becz of my MS office is 2010 x32 only, and then my problem solved.

thank you again :):):)

NagaNimesh 11474558 20-Jul-16 7:12am

pleasure :) all the best

Member 11859517 21-Jul-16 0:55am

hi,
is there any way to do this without installing ms access into machine????,
here we need to install ms access.

thanks

NagaNimesh 11474558 21-Jul-16 1:50am

hy common yar without installing ms access how can u get file from ms access db to excel

NagaNimesh 11474558 21-Jul-16 1:52am

u can go with ms access 2003 as u can get .mdb file then u can export to excel but for this the provider is not OLEDB.12.0 google for it k
but for ms access 2007 and after (.accdb) u have go with this provider understand??

Member 11859517 19-Jul-16 0:44am

And I have more table in .mdb file i want each table in separate tab(sheet) is it possible.

OriginalGriff · Accepted Answer · 2016-07-18T02:22:00

Solution 1

You don't export it from MDB, you should try importing it into Excel.
That's pretty easy: How Do I Import Microsoft Access® Data into Excel® | Inbox Email & Resource Center[^]

Posted 18-Jul-16 2:22am

OriginalGriff

Comments

Member 11859517 18-Jul-16 8:32am

heyy thanks,,
displaying exactly same that i want. But i want same in programmatically, like on button click.
thanks