将文件插入访问表 [英] Insert file into access table

问题描述

我有一个名为Reports的表，该表具有3个字段ID(自动编号)，filename(字符串字段)，theFile(附件字段).

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

我要运行的是SQL查询，然后将PDF文件插入附件字段(theFile).

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

可以说PDF文件位于C:驱动器(C:\ report1.pdf)中，我已经尝试了下面的SQL查询，但是它不起作用.我知道将文件存储在数据库中不是一个好习惯，但我只想尝试一下:

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 & ")"

推荐答案

将文件存储在数据库中是标准做法. Access当然支持它，但是不通过SQL.您必须使用DAO，如

It's standard practice to store files in a database. Access certainly supports it, but not through SQL. You'll have to use DAO, as detailed at http://msdn.microsoft.com/en-us/library/office/bb258184%28v=office.12%29.aspx

这篇关于将文件插入访问表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！