Insert a file in a SQL field

Ask a Question related to Microsoft SQL / MS SQL Server, Design and Development.

  1. #1

    Default Re: Insert a file in a SQL field

    You can store the file in a column with datatype image. This holds up to 2GB
    of binary data.

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "James Duran" <noname@nowhere.com> wrote in message
    news:0c3501c34141$cfb26300$a101280a@phx.gbl...
    > Hi,
    > can I insert a XLS file in a database (to store an
    > associated file to a register?
    >
    > How, if is it possible??
    >
    > Cheers,
    > James

    Jacco Schalkwijk Guest

  2. Similar Questions and Discussions

    1. problem with insert to memo field
      I've moved a web site that I manage from a CF server 5 to CF MX. I didn't change anything in the database itself, the memo field are configured...
    2. Iterative Insert with Variable Field Name
      Hello, Someone must have come across this already, I need help with this insert query I have. I have a form that has variables as such:...
    3. Insert TAB into calculated field
      I'm trying to create a function with FM Pro 4.1 where a user can click a button on a screen causing a group of five fields to be copied into the...
    4. Insert Date into Memo Field
      I wold like to be able to insert a date into a memo field. I have a form that sets the date and then copies it into the field into a bound control,...
    5. How to Insert documents to a BLOB field
      Hi, I have an Access Front-End application and an Oracle Back-End for my tables. I have a BLOB field in one of the tables. I use Access form to...
  3. #2

    Default Re: Insert a file in a SQL field

    Thanks Jacco !

    James
    >-----Original Message-----
    >You can store the file in a column with datatype image.
    This holds up to 2GB
    >of binary data.
    >
    >--
    >Jacco Schalkwijk MCDBA, MCSD, MCSE
    >Database Administrator
    >Eurostop Ltd.
    >
    >
    >"James Duran" <noname@nowhere.com> wrote in message
    >news:0c3501c34141$cfb26300$a101280a@phx.gbl...
    >> Hi,
    >> can I insert a XLS file in a database (to store an
    >> associated file to a register?
    >>
    >> How, if is it possible??
    >>
    >> Cheers,
    >> James
    >
    >
    >.
    >
    James Duran Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139