By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,646 Members | 2,063 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,646 IT Pros & Developers. It's quick & easy.

Image file insertion into Database

P: 89
Hi All,
I tried a lot also followed many previous example, still i cant get proper idea that how to insert an image file into database? I using VB and Access. for example:
My File image file is "C:\test\x.dwg", I want to insert into table test(img, ID) . Please help me if u can, Thanks advance, Sam
Dec 6 '07 #1
Share this Question
Share on Google+
5 Replies


debasisdas
Expert 5K+
P: 8,127
You need to convert the file into byte stream and store in database file.
Dec 6 '07 #2

debasisdas
Expert 5K+
P: 8,127
Please find the details here.
Dec 6 '07 #3

P: 89
Hello, thanks very much for ur valuable reply, However I cant understand which one is the image fime and which field of table will keep ? Sorry Just if more clear idea abt that, Thx
Dec 6 '07 #4

QVeen72
Expert 100+
P: 1,445
Hi,

Check This Out

The Code is for Oracle (Long Raw datatype)
For Access, Field datatype is : OLE Data

Regards
Veena
Dec 6 '07 #5

debasisdas
Expert 5K+
P: 8,127
Hello, thanks very much for ur valuable reply, However I cant understand which one is the image fime and which field of table will keep ? Sorry Just if more clear idea abt that, Thx
strFileNm is th ename of the file
logo is the name of the field in database table.

for oracle datatype should be lob or long raw
for access datatype should be ole
Dec 6 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.