Re: import text file to access table using vb

[gracehskuo]

hello,how to import text file to access table using vb?what i'm trying to do is import the text data from the select text file using commandialog select desire text file to import into the access database.i upload the text file here,the data want to import from text is only the value.please help.Thanks alot!


this is the commondialog i done with!

Private Sub CmdSearch_Click()
On Error GoTo ErrHandler

    With CommonDialog1
        .CancelError = True
        .Filter = "General Modules (*.txt)/*.txt"
        .ShowOpen
  End With   
   
ErrHandler:
    Err.Clear
    Exit Sub

End Sub

Thanks for help!