As i am importing several data files into one database (in Access) I am trying to code a list field with the appropriate file names using a SQL statement, this is what i have so far:
The red line is the SQL statement i came up with that is not working, any help would be awesome!
If Right(objF1.Name, 3) = "CSV" Then
FileName = objF1.Name
DoCmd.TransferText acImportDelim, "ImportSpec", "ELDO_COMBINED", orgLocation & objF1.Name, False
DoCmd.RunSQL "UPDATE ELDO_COMBINED '" & FileName & "' WHERE ELDO_COMBINED.LIST IS NULL ;"