G
Guest
Hi,
within an Access.mdb project, I have connected to another
Access mdb file. A Table contains a column with OLE-Object
data (containing .jpg images).
Now I have to import this data into vba code and then to
insert it into a SQL server data base using "INSERT
INTO .." statements.
First question: Is it correct to define a variable
as "Dim Pic as Object", then using "Set Pic = CreateObject
("Forms.Image.1")", followed by setting "Pic = RS.fields
("JPEGIMG") when "JPEGIMG" is the field that contains the
image data?
Second question: If after the steps above the VBA
variable "Pic" contains the image data, what do I have to
write into an "INSERT INTO [TableName] ([JPEGIMG]) VALUES
( ?????? )"-statement to move this data into the SQL
server table which contains a field "JPEGIMG" formattet
as "IMAGE NULL" data?
Best regards
Norbert
within an Access.mdb project, I have connected to another
Access mdb file. A Table contains a column with OLE-Object
data (containing .jpg images).
Now I have to import this data into vba code and then to
insert it into a SQL server data base using "INSERT
INTO .." statements.
First question: Is it correct to define a variable
as "Dim Pic as Object", then using "Set Pic = CreateObject
("Forms.Image.1")", followed by setting "Pic = RS.fields
("JPEGIMG") when "JPEGIMG" is the field that contains the
image data?
Second question: If after the steps above the VBA
variable "Pic" contains the image data, what do I have to
write into an "INSERT INTO [TableName] ([JPEGIMG]) VALUES
( ?????? )"-statement to move this data into the SQL
server table which contains a field "JPEGIMG" formattet
as "IMAGE NULL" data?
Best regards
Norbert