如何将.mdb文件(它在文件夹中)导出到excel文件? [英] How to export .mdb file (it is in folder) to excel file?
问题描述
我想将数据从我文件夹中的.mdb文件导出到c#中的excel文件,
如何做到这一点任何人都可以帮我处理一段代码。
thanx提前
sushil
我尝试过:
我尝试使用文件副本(。mdb,excel),但我认为不正确,
所以有任何好方法可以做到这一点,
我也在谷歌搜索,但大多数解决方案是直接使用数据库连接,
但在我的情况下.mdb文件在文件夹中。
注意:这里我以编程方式创建excel文件。
plz hel me。
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.
推荐答案
C#将表导出到Excel - 堆栈溢出 [ ^ ]
初读时.mdb中的所有表到数据集然后参考上面的链接。希望您理解:)
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 :)
您不从MDB导出它,您应该尝试将其导入Excel。
这很简单:如何导入Microsoft Access®数据到Excel®|收件箱电子邮件&资源中心 [ ^ ]
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[^]
这篇关于如何将.mdb文件(它在文件夹中)导出到excel文件?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!