I have a table in excel with image in the last cell of every row, how can I export it to Access database?

Question

Hello everybody,

I have a table in excel with image in the last cell of every row, how can I export it to Access database?

the cells contain the image itself not a link to its location.

Answer 1

Hi,

Here's how you can do it-

1. In Access, create a table that includes fields for the data you want to associate with the images and a field to store the images. For example, you might have fields like "Name," "Description," and "Image."
2. In Access, go to the "External Data" tab.
3. Click "Excel" to create a linked table.
4. Browse to and select your Excel file.
5. Choose the worksheet that contains your table.
6. Follow the wizard to link the table.
7. Once you've linked the Excel table, create a new table or query in Access to import data from the linked table. This allows you to manipulate the data as needed before storing it.
8. In Access, you can use an Attachment field to store images. In the table design, change the field type to "Attachment."
9. You'll need to manually import each image from the linked Excel table to the Access table. Double-click the attachment field in Access to open a dialog that allows you to insert an image.
10. After importing the images, make sure to update the other fields in the Access table as needed to match your Excel data.

Best Regards.