Access(テーブル、クエリ)をCSVファイルとして出力する方法
VBAでCSVファイルを作成して出力する方法
Sub Exp_CSV() Dim dbs As DAO.Database Dim rst As Dim rst As DAO.Recordset Dim lngFileNum As Long Dim strOutPut As String lngFileNum = FreeFile() Open "C:\work\expdata.csv" For Output As #lngFileNum Set dbs = CurrentDb Set rst = dbs.OpenRecordset("M_DATA") With rst strOutPut = "" Do Until .EOF strOutPut = strOutPut & !コード & "," & !品名 & "," & _ !備考 & "," & !数量 & "," & !仕入先 & vbCrLf .MoveNext Loop .Close End With Print #lngFileNum, strOutPut Close #lngFileNum End Sub