program til insert af binære filer

Cant you use DTS from SQL Server? (Import/Export wizard)

jeg skal overføre en masse word-dokumenter - i DTS kan jeg kun overføre en tekstfil af gangen (mener jeg).

Not sure about that. The wizard can actually import MANY data types, although I'm not sure about a Word document!

ok - jeg vil prøve at kigge nærmere på DTS.

Tak :o)
You should take a look at Books Online, there is a VERY good documentation on DTS. You can use VB Script Java or COM objects to transform your data, so I am quite sure that you shoul be able to import your Word docs.

Jeg har nu prøvet med noget VB:

nedenstående virker fint. Men jeg mangler stadig at få filerne læst ind i det binære felt i databasen. Nogen forslag?

Private Sub Command1_Click()

svar = MsgBox("Kopier filer?", vbYesNo)
' 6 = yes, 7=no

If svar = "7" Then
MsgBox ("Du valgte IKKE at kopiere")
Else
Call CopyFiles

MsgBox "Filkopiering til database færdig"

End If

End Sub


Sub CopyFiles()

Dim fso As Scripting.FileSystemObject
Set fso = New Scripting.FileSystemObject

Source = "C:\filer\"

ConnectionstringToDB = "Driver={SQL Server};Server=xx;Uid=xx;Pwd=xx;Database=xxx"
Dim objConn As New ADODB.Connection
objConn.Open (ConnectionstringToDB)

If fso.FolderExists(Source) Then
    Set myFolder = fso.GetFolder(Source)
    Set myFiles = myFolder.Files
    For Each Item In myFiles
   
    FileName = Item.Name
   
    objConn.Execute ("INSERT INTO table (File_Name) VALUES ('" & FileName & "')")
    Next
End If

Set fso = Nothing

End Sub

Sorry I dont. But to be honest it isnt a good practice in having the file (Word document) in the database. More often than not only the path and filename are stored in the dB.
Another thing, if I remember correctly image files are NOT actually stored in the database anyway!

You could also take a look at help on "image" data types in Books online.

Jeg SKAL gemme filerne binært i databasen.

You could also take a look at help on "image" data types in Books online.