code_junkie

How to import a files like PDF MP3 DOC XLS into a MS SQL Server Datatable field using VBA code in Access2007

Nov 12th, 2011
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. Set rs = New ADODB.Recordset
  2. rs.Open "select * from YourTable", Connection, adOpenKeyset, adLockOptimistic
  3.  
  4. Set mstream = New ADODB.Stream
  5. mstream.Type = adTypeBinary
  6. mstream.Open
  7. mstream.LoadFromFile "c:myfile.pdf"
  8. rs.Fields("blobfield").Value = mstream.Read
  9. rs.Update
Add Comment
Please, Sign In to add comment