inserting data from a file in access table

Question

I have a form in access with a button that lets user select a text file(file dialog). How can I insert the data from that selected file in a table?

Here is my code for selecting a file:

Sub InsertData()

Dim fDialog As Object  
 Set fDialog = Application.FileDialog(1) 
with fDialog 
 .AllowMultiSelect = False
 .Show  
 End If 

End Sub

Thanks in advance

Answer 1

You may be able to use DoCmd.TransferText