Convert attachment to ole object

[zezo2021]

Hello friends
Can I Convert the attachment to ole object?
Notes
the attachment contains a lot of records
I tried but not work

maybe any developer create VBA or any tricks can help me

Thank you

 

[arnelgp]

are all the attachments same type (ie, images only or pdf only, etc).

 

[zezo2021]

are all the attachments same type (ie, images only or pdf only, etc).

Hello

Thank you so much

PDF

 

[arnelgp]

can you post the table with attachment field?

 

[zezo2021]

DB
with attachment

 

[zezo2021]

 

[arnelgp]

here try this db. run form1 and select your database.
complete all comboboxes and click Convert.
records will be saved to Table1.
note, you need to delete any records in table1 if you want
to start new conversion.

 

[zezo2021]

Thank you so much

Testing now

 

[zezo2021]

Hello
This error appears

@arnelgp

I suggest if possible:

use the same ID from the import attachment table so I can review between the old table and the new table

because I can't review by foreign key because I don't find some fk and all data not imported because the above issue and there duplicate in FK

 

[arnelgp]

try this.
i am confused with your table, how can you linked your table using the PK?
you should use the Parent ID field? anyway you know your db well so do as you wish.

 

[zezo2021]

Thank you so much
Testing now

 

[zezo2021]

one error

 

[arnelgp]

maybe the file is too big?
can you post the table you are currently converting?

 

[zezo2021]

with Docx extension only

I remove this extension and work

 

[zezo2021]

Hello
@arnelgp

all file is converted from Attachment to ole object


my problem now:

Is the size of the DB


Do you have any solution for compacting the OLE Field to the lowest size?

my plan is:

1- download the file on HD (PDF)
2- Compact the file to minimum quality
3- reattach the file to the field (ole Object) Auto again

or any other solution you prefer


Thank you so much for all your efforts