CONTACT US
568-3-53 (3rd Floor), Kompleks Mutiara, 3 1/2 Mile, Jalan Ipoh
51200 Kuala Lumpur, Malaysia
6012 9714904
support@yohz.com
https://www.yohz.com
Copyright © 2005 - 2023 Yohz Software,
a division of Yohz Ventures Sdn Bhd.
ALL RIGHTS RESERVED.
All trademarks or registered trademarks are property of their respective owners
Upload images and files into
OLE Object fields with
Access OLE Import
•
upload images and files into OLE Object fields
•
supports Access 2000 to the current version
•
also supports any OLE Object fields created in SQL
Server, MySQL, MariaDB, Oracle, PostgreSQL, SQL
Server Compact, SQLite, and ODBC data sources
Frequently asked questions
> Do I have to back up my database before
uploading my files?
Yes.
> Do I need Excel installed to run the upload?
No. Also, you can create the data file using Excel or any
compatible applications like Libre Office or Open Office.
> Can I upload other data in addition to files?
Yes, you can upload integer values and text values into your
tables by providing the field definitions and values in the data
file.
> Can I upload to a SQL Server database that has
OLE-Object type fields?
Yes. Access OLE Import supports other database engines like
SQL Server, PostgreSQL, MariaDB, MySQL, and many more.
See here for the list of supported database engines.
> Can I also store the uploaded file properties?
Yes. You can store file properties like the file size, created and
modified dates, file paths etc into your table. See here for how
to use the additional file name columns.
> Do I really need to back up my database first?
Absolutely yes.