Graham,

The only way I can think of to handle this is through VBA code which
imports the .csv file line by line and appends records to the table
through a recordset operation. Here's some sample aircode:

Sub import_CSV()
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim vF(1)
vFile = "C:\SomeFolder\MySourceFile.csv"
vTable = "MyDestinationTable"
If Dir(vFile) = "" Then
    MsgBox "File does not exist.", vbCritical
    Exit Sub
End If
Open vFile For Input As #1
Set db = CurrentDb
Set rst = db.OpenRecordset(vTable)
Do Until EOF(1)
    Line Input #1, vLine
    vFields = Split(vLine, ",")
    For i = 0 To 1
        If vFields(i) <> "" Then
            vF(i) = vFields(i)
        Else
            vFields(i) = vF(i)
        End If
    Next
    rst.AddNew
    For i = 0 To 3
        rst.Fields(i) = vFields(i)
    Next
    rst.Update
Loop
Close #1
rst.Close
Set rst = Nothing
Set db = Nothing
End Sub

Note: To run this code, an appropriate DAO Object Library reference is
required. While in the VB editor window, go to menu item Tools >
References; check if a Microsoft DAO reference is present among the ones
checked at the top of the list. If not, scroll down to find the
appropriate Microsoft DAO X.X Object Library reference and check it. The
appropriate reference is DAO 3.51 for A97, DAO 3.6 for A2K or later.

As a matter of fact, if you are still on A97 then function Split is not
available, in which case you'll have to use a user-defined function to
do the job; let me know.

HTH,
Nikos