Importing file in to MS Access Table


A

Anurag Jain

Hello,

I am a new user of MS Access and is completely new to this forum as well.

I am looking for some help on my first application in access that I am
designing.

I am creating an MS Access 2003 application with VBA in front end and MS
access database at the backend. I have a database in my table called
employees and I would like to save a pdf or a doc file in the resume field of
each employee record.

I tried to upload the file using DAO but it only saves the file name as BLOB
in the resume field inside the table and not its content.

Can someone please advise me what could I be doing wrong or if there is a
better way to approach this problem.

Thank you in advance,

Anurag
 
Ad

Advertisements

A

Anurag Jain

Thank you, Arvin for your response. The way you are suggesting is a good one
but i would also like to look into the possibility of importing the files in
the table field. That way i think the application would be more user friendly
and easier to circulate.
Please suggest and Thank you in advance.
 
A

Arvin Meyer [MVP]

As Duane mentioned, Access 2007 supports this. Trying to import fields into
an OLE field requires huge amounts of database space and doesn't support
storing very many files.

If you distribute your files in a single Folder with the PDFs being in a
subfolder, you accomplish the task of both user firendly, and ease of
circulation. Instead of storing the full path, you would then use:

CurrentProject.Path & "\FolderNameFor PDFs\" & FileName.PDF

Now you can store it anywhere.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
 
Ad

Advertisements

A

Anurag Jain

Thank You, Arvin and Duaue for all your help. I think that i will go with
your suggestion and put resumes in seperate folder and save their path in the
database.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top