Attaching a spreadsheet to a record in a databas

J

JudithJubilee

Hello Janice,

If you want to attach anything other than typed text to a record you will
need an extra field

Go to the design view of the table and add another field
Choose OLE Object as the data type
Choose to view the datasheet - you will see an empty cell.
Right click the cell and choose Insert Object
Choose From File + Browse
Find the file you want and choose OK
Tick the Link box if you want an up-to-date spreadsheet to be attached

If you have any problems with this please repost

Hope this helps

Judith
 
J

Janice

Thank you Judith. Can I attach a spreadsheet to a record in a form without
it showing up in all the records?
 
C

Chipmunk

I would like to know this too. Thanks.

Janice said:
Thank you Judith. Can I attach a spreadsheet to a record in a form without
it showing up in all the records?
Click to expand...
 
J

Janice

There are two ways:

In your Access database, in Tables, go to Datasheet View and go to Insert in
your toolbar up above and select Hyperlink Column or, in Tables, go to Design
View and select the field that you want to have spreadsheets attached to. In
the Data Type column, select Hyperlink from the drop down arrow. While in
Datasheet View, select the record that you want to attach a spreadsheet to.
Go into your hyperlink field/column and either select Insert Hyperlink from
your toolbar up above or right click and select Hyperlink, Edit Hyperlink.
It is self-explanatory from there. The only thing to remember is that this
field/column will be a hyperlink field. You will not be able to enter any
other data in it besides hyperlinks.

Let me know if you need any help.

Janice
 
Top