Yes, after your suggestion of course, and the sqlstring looks like this:

SELECT 1 AS ImageID, '1.jpg' As ImageName,

BulkColumn FROM OPENROWSET( Bulk 'D:\Mijn Documenten\Documents\DWCoureurLocaleData\Irfanview_26012011\1.jpg',

SINGLE_BLOB) As BLOB

So I think that...

Hi Robin,

Yes, this is more a eastern present: thanks a lot for the good job. But it still doesnot function as expected. I changed the folderpath in:

'D:\Mijn Documenten\Documents\DWCoureurLocaleData\Irfanview_26012011'

So nothing...

Thanks a lot so far. I'll do my best to solve the problem.

Grz

Robert

Hi folks,

We give it another try. The situation is as follows:

1. I filled the Renner_Foto table with an ImageID and an ImageName.

2. I made a tblNummer and a vwNummer. In...

Last call for today on my part. I am running around in circles.

When I execute the following code:

USE WielerDatabaseSQL

GO

DECLARE @counter int

DECLARE @folderpath AS varchar(4000)

DECLARE @fullpath AS varchar(4000)

DECLARE @sqlstring AS...

I solved one problem: my directory path contained a space in [Mijn documenten]. Putting that between quotes solved the non-executing problem. Next I try to get things running. Any help...

I am looking into de exec command and I don't understand how the current directory (dir) can match with my photo-directory when no further information has been supplied to the...

Can you give me a clue? Flush the insert mode? I don't get any further than using your code and increase the counter to < 680. According to the jpg...

OK, we try it out. An answer to one of your former questions: the row is not inserted. I closed up everything, so the transaction must be closed. So the...

Sorry I missed your second suggestion. This is going a bit too far for me: with other words I don't quite understand your code. You produce a temp table with...

Yes I am a bad listener, sorry for that. I didnot really understand where you were talking about. Though with your example the sun is coming through, I could copy...

Guys, thanks for all the tips and suggestions. The quote-tip I understand, but the copy/paste tip in textmode I cannot follow (grasshopper level remember). Furthermore I cannot solve that item,...

Thanks for the additions (and the handy double click tip) - I think the quotation is OK now, but we get another problem:

Msg 214, Level 16, State 2, Procedure sp_executesql,...

Hello Robin,

Thanks for your great advise - we are getting in the right direction.

I changed your code somewhat (ImageName = ' ', we fill that in later). This gives...

Hi folks,

Because of a lack of reactions on my image-post I try it a second time.

1. My problem was: how to automate a process of inserting images into a table...