You can use the wizard to create an import procedure and save the procedure with a name. With that you can call the name using Docmd.
Here is some code I use to loop through a folder on a server and grab all of the text files it can find. It imports the text files using the procedure I created using the wizard. The name I gave the procedure is "CustomSpec". If your files are .txt or .CSV then DoCmd.TransferText will work. Otherwise you will need something like DoCmd.TransferSpreadsheet acImport.
Code:
Dim strFilename As String
Dim strPath As String
strPath = "\\ServerName\FolderName\"
strFilename = Dir(strPath + "*.txt", vbHidden) 'gets first txt file in path specified
Do While strFilename <> "" 'will cause to loop through all txt files in path
DoCmd.TransferText acImportFixed, "CustomSpec", _
"tblImportStuff", strPath & strFilename, 0
Kill strPath & strFilename
strFilename = Dir 'grabs next txt file
Loop