您好我有Microsoft Access数据库(.mdb)文件表转换为csv [英] hi i having Microsoft Access Database (.mdb) file tables to convert to csv

问题描述

请帮助我，先生...


谢谢
praveen

please help me sir...


thank you
praveen

推荐答案

我将从表中选择所有内容，然后使用流编写器将其导出到csv

I would select everything from the table and use a stream writer to export it to csv

        Dim cn As New OleDbConnection
        Dim qry As String = "SELECT * FROM YOURTABLE"
        Dim myReader As OleDbDataReader
Dim myWriter As New StreamWriter(DIRECTORY AND NAME OF THE FILE)

        Try

            cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & PATH TO YOUR TABLE& ";Persist Security Info=True"

            cn.Open()

            Using cmd As New OleDbCommand(qry, cn)

                myReader = cmd.ExecuteReader()
                myWriter.Writeline(ALL YOU HEADERS SEPERATED BY COMMAS)
                While myReader.Read()
                    string line = myReader(FIELD IN YOUR TABLE) +
                    "," + myReader(FIELD IN YOUR TABLE)

                    myWriter.Writeline(line)
                End While

            End Using

            myReader.Close()

            cn.Close()
        Catch ex As Exception
       
        End Try

这是您的意思吗?

is this what you meant?

请参阅

这篇关于您好我有Microsoft Access数据库(.mdb)文件表转换为csv的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！