CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. September 6th, 2001, 02:12 PM #1
    artnature
    artnature is offline Junior Member
    Join Date
    Mar 2000
    Location
    Toronto Canada
    Posts
    8

    Inserting and Retrieving .doc and xls. files in SQL7

    I am trying to create an application in VB where I can add and retrieve Microsoft Word documents and Microsoft Excel spreadsheets in a Microsoft SQL7 database as recordsets. I know that in order to save all the formats as well as their contents I need them to be inserted in an image data type. Could anyone give me some tips in order to achieve this.
    Thanks in advance.
    Any other alternative suggestions are welcome.

    Reply With Quote Reply With Quote
  2. September 6th, 2001, 02:15 PM #2
    Iouri
    Iouri is offline Elite Member
    Join Date
    May 2000
    Location
    New York, NY, USA
    Posts
    2,878

    Re: Inserting and Retrieving .doc and xls. files in SQL7

    Why won't you save the path to the doc in the database. When you call this field just shell to the document in the path

    Iouri Boutchkine
    [email protected]
    Iouri Boutchkine
    [email protected]
    Reply With Quote Reply With Quote
  3. September 11th, 2001, 03:09 PM #3
    artnature
    artnature is offline Junior Member
    Join Date
    Mar 2000
    Location
    Toronto Canada
    Posts
    8

    Re: Inserting and Retrieving .doc and xls. files in SQL7

    Thank you so much for your advice, but I would still like to save it all the data in the SQL Server for security reason. If you know how to write and read image data type from VB I will really apreciate it. Thanks again.

    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured