I have a table named `Reports` which has 3 fields `ID` (auto number), `filename` (string field), `theFile` (attachment field).

What I want to is to run a SQL query and insert a PDF file into the attachments field (`theFile`).

Lets say the PDF file is located in the C: drive (C:\report1.pdf), I have tried the SQL query below but it is not working. I know its not good practice to store files in a database but I just want to try it out:

```
CurrentDb.Execute "INSERT INTO Reports (filename,theFile) VALUES ('report1'," & C:\report1.pdf & ")"

```