Results 1 to 3 of 3
  1. #1
    stalk is offline Competent Performer
    Windows 10 Office 365
    Join Date
    May 2014
    Posts
    143

    How can we download file attachments from SQL in a file


    I have at least 3 file attachments for each of my customers and I want to request SQL Admin to create a stored procedure to run this daily and export them as flat files. Is this do able?
    If so, what will be the variable type for these attachments? Thank you

  2. #2
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Use field type: binary. To import/export data: you can use SSIS (integration services) and run a daily job that starts the package or use a method as described in https://www.mssqltips.com/sqlservert...or-sql-server/ .

  3. #3
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    I used AppendChunk method to do that (and used BLOB as data type), here is a related thread:
    https://www.access-programmers.co.uk...le-bes.318821/

    Depending on your driver you can also try Stream.Read\Stream.Write.
    https://docs.microsoft.com/en-us/off...ile-method-ado
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Download a File From ShareFile
    By jo15765 in forum Programming
    Replies: 4
    Last Post: 01-20-2020, 02:16 PM
  2. Access VB download Excel file from website
    By lizzycole in forum Import/Export Data
    Replies: 7
    Last Post: 04-01-2013, 02:54 PM
  3. Replies: 2
    Last Post: 10-05-2012, 01:50 PM
  4. Attachments with file name
    By JayX in forum Forms
    Replies: 1
    Last Post: 03-06-2012, 03:08 PM
  5. download test file from WS_FTPin Access VBA
    By dollygg in forum Access
    Replies: 0
    Last Post: 07-28-2009, 08:08 PM

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