A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Importing file in to MS Access Table



 
 
Thread Tools Display Modes
  #1  
Old March 17th, 2010, 04:10 AM posted to microsoft.public.access.gettingstarted
Anurag Jain
external usenet poster
 
Posts: 3
Default Importing file in to MS Access Table

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
  #2  
Old March 17th, 2010, 05:46 AM posted to microsoft.public.access.gettingstarted
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Importing file in to MS Access Table

Save the files in a folder on the hard drive and store the path to the
employee file in a field in his record. Open the PDF in response to a souble
click event or a button click event. See the following:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Anurag Jain" wrote in message
...
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



  #3  
Old March 18th, 2010, 01:25 PM posted to microsoft.public.access.gettingstarted
Anurag Jain
external usenet poster
 
Posts: 3
Default Importing file in to MS Access Table

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.

"Arvin Meyer [MVP]" wrote:

Save the files in a folder on the hard drive and store the path to the
employee file in a field in his record. Open the PDF in response to a souble
click event or a button click event. See the following:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Anurag Jain" wrote in message
...
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



.

  #4  
Old March 19th, 2010, 02:44 AM posted to microsoft.public.access.gettingstarted
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default Importing file in to MS Access Table

You might want to wait for Access 2007 since it will support "attachment"
fields with compressed storage. Check out Allen Browne's page on the new
features at http://www.allenbrowne.com/Access2007.html.

--
Duane Hookom
MS Access MVP


"Anurag Jain" wrote in message
...
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.

"Arvin Meyer [MVP]" wrote:

Save the files in a folder on the hard drive and store the path to the
employee file in a field in his record. Open the PDF in response to a
souble
click event or a button click event. See the following:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Anurag Jain" wrote in message
...
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



.

  #5  
Old March 19th, 2010, 02:37 PM posted to microsoft.public.access.gettingstarted
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Importing file in to MS Access Table

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


"Anurag Jain" wrote in message
...
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.

"Arvin Meyer [MVP]" wrote:

Save the files in a folder on the hard drive and store the path to the
employee file in a field in his record. Open the PDF in response to a
souble
click event or a button click event. See the following:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Anurag Jain" wrote in message
...
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



.



  #6  
Old March 22nd, 2010, 01:46 AM posted to microsoft.public.access.gettingstarted
Anurag Jain
external usenet poster
 
Posts: 3
Default Importing file in to MS Access Table

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.

"Arvin Meyer [MVP]" wrote:

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


"Anurag Jain" wrote in message
...
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.

"Arvin Meyer [MVP]" wrote:

Save the files in a folder on the hard drive and store the path to the
employee file in a field in his record. Open the PDF in response to a
souble
click event or a button click event. See the following:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Anurag Jain" wrote in message
...
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


.



.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.