Take a copy of the file and try and open that instead of the original.
I can provide the code for you, this code will only open the file and try and input one record or line of data.
If it works I can modify it to loop through the data and add it to a table.
Dim strFile as string, strInput as string
On Error GoTo errorcatch
strFile = C\Users\Dave\Desktop\Smith\Mar.csv
Open strFile For Input As #1
Line Input #1, strInput
MsgBox strInput
Close #1
Exit Sub
errorcatch:
MsgBox Err.Description & " " & intCount & " " & strInput
Close #1