طيب غير الفانكشن الى عندك بهذا الكود ....
On Error GoTo Error_Handler
Dim MyFile As String
Dim db As Database
Dim sSQL As String
Set db = CurrentDb()
If Right(strPath, 1) <> "" Then strPath = strPath & ""
If strFilter = "" Then strFilter = "*"
MyFile = Dir$(strPath & "*." & strFilter)
Do While MyFile <> ""
myfile1 = Left([MyFile], InStrRev([MyFile], ".") - 1)
sSQL = "INSERT INTO [BASIC_DATE] (crn) VALUES(""" & myfile1 & """)"
db.Execute sSQL, dbFailOnError
MyFile = Dir$
Loop
Error_Handler_Exit:
On Error Resume Next
Set db = Nothing
Exit Function
Error_Handler:
MsgBox "The following error has occured" & vbCrLf & vbCrLf & _
"Error Number: " & Err.Number & vbCrLf & _
"Error Source: ImportDirListing" & vbCrLf & _
"Error Description: " & Err.Description, vbCritical, _
"An Error has Occured!"
Resume Error_Handler_Exit