+ Reply to Thread
Results 1 to 4 of 4

Import data from Excel to Access - Image not importing

  1. #1
    Registered User
    Join Date
    11-21-2018
    Location
    Vilanculos
    MS-Off Ver
    Office 2016
    Posts
    10

    Import data from Excel to Access - Image not importing

    Good day,

    I am trying to copy an Excel sheet of more than 2500 lines into Access.
    There is four columns with data on the Excel sheet (no problems with importing these in Access).
    The fifth column is an image.
    I cant seem to import or ''copy and paste'' the image.

    Can someone please assist?

    I have tried to do research on this, and all I can find is coding and modules, which I know nothing about.

    Desperate for some help please!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Import data from Excel to Access - Image not importing

    Look at this link

    https://dev.to/accessrepair1/how-to-...-database-1l8b
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    11-21-2018
    Location
    Vilanculos
    MS-Off Ver
    Office 2016
    Posts
    10

    Re: Import data from Excel to Access - Image not importing

    Hi Alan.
    Thanks for this, but it doesnt answer my question fully.
    I have figured out how to add the attachment column. After adding the attachments column, I then need to add the images one by one.

    I need to find a way to ''import'' each image on all 2500 lines, in batches, not one by one.

    Hope that makes sense?

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Import data from Excel to Access - Image not importing


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Import a image from a data bank to excel
    By pmoreira in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-02-2017, 10:53 AM
  2. Importing Access Data into Excel Tab
    By certifydgangsta in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-17-2014, 11:02 AM
  3. Importing Excel Data into Access
    By NSTurk725 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2010, 11:23 AM
  4. Importing Data from Access to Excel
    By dnnr in forum Excel General
    Replies: 0
    Last Post: 08-06-2007, 05:22 PM
  5. Importing data into Excel from Access
    By Blondegirl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2006, 05:51 PM
  6. Importing data from Access to Excel, but I need to vary the table from Access
    By Liz L. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2006, 09:15 PM
  7. [SOLVED] Importing Data from Access into Excel
    By vnvkatz in forum Excel General
    Replies: 3
    Last Post: 06-09-2005, 12:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1