Results 1 to 4 of 4
  1. #1
    TanyaF is offline Novice
    Windows 10 Access 2007
    Join Date
    Feb 2016
    Location
    Grass Valley, CA
    Posts
    3

    Exporting a database to Excel with list of attachments

    New to the forum and have searched around but not finding a thread with exactly what I am looking for (and a novice with Access).....I have exported my inventory database to Excel before but was wondering if there is a way to do the same thing but also list the attachments (drawings) that are attached to each part number? Along those lines also, to do the same thing with the drawings in a field (as pdf's or jpg's) on the part number line item in the Excel file. (Probably more likely to be able to do it the first way!) Thanks ahead of time for any info.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Are the drawing files located on a server and the db holds the location path?
    or
    are the drawings actually embedded in an Attachment field on 1 record?

  3. #3
    TanyaF is offline Novice
    Windows 10 Access 2007
    Join Date
    Feb 2016
    Location
    Grass Valley, CA
    Posts
    3
    embedded in an attachment field

  4. #4
    TanyaF is offline Novice
    Windows 10 Access 2007
    Join Date
    Feb 2016
    Location
    Grass Valley, CA
    Posts
    3
    Hi again,
    I am actually assuming they are embedded.....I point toward the drawing on the server and it attaches, but if I remove it from the server I can still view it in that record. So, after I choose it maybe Accesss is embedding it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Exporting Attachments
    By Hamm in forum Import/Export Data
    Replies: 8
    Last Post: 10-22-2012, 08:19 AM
  2. Replies: 7
    Last Post: 10-11-2012, 01:08 PM
  3. Exporting Attachments
    By kp123 in forum Access
    Replies: 1
    Last Post: 09-25-2012, 01:19 PM
  4. Exporting 2010 Web Database report to Excel
    By rogstepper in forum Import/Export Data
    Replies: 2
    Last Post: 09-12-2012, 01:52 PM
  5. Exporting Data to Excel from a Web database
    By need_help12 in forum Import/Export Data
    Replies: 1
    Last Post: 05-16-2012, 04:59 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums