This must be possible because I believe I've done it before. Here's my query:
insert into exampleFiles Values(NEWID(), cast('c:\filename.zip' as varbinary(max))
Obviously that just inserts the text in between the quotes and not the file from that location. There must be a simple tsql bit of language that I'm forgetting. Thanks