Import and export documents

I

Imran Ghani

Hi! I am building my application with MS Access 2007 with VBA. I want to have
buttons in my application, through which users could import documents from MS
Office applications and save them in the database. Also one button to export
documents in MS Office applications. Thanks in advance for guidance.
 
K

Klatuu

Do not put documents in the database. It will bloat the database and will
soon excede the 2 Gig size limit for an mdb or accdb file.
The better way is to use a specific folder to hold the documents and use
either a text or hyperlink field to save the path to the document.
 
I

Imran Ghani

Thanks for your advice. Kindly also guide me about how to achieve this task.
 
K

Klatuu

It is as simple as I described in my first post. You use a text or hyperlink
field to store that path of the document. When you want to open the
document, you either use the Shell function if the field is text or the
FollowHyperLink method is the field is a hyperlink field.
 

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

Similar Threads

Interchanging values between two text boxes 2
Controlling another application with VBA 4
XML Import & Export in Access 2003 2
Custom Ribbon - ExportExcel not showing 0
Attach word document with email Programmatically 1
Access MS Access Database templates for document management 0
Export to Excel 1
Import Documents from word 1

Top