PPRuNe Forums - View Single Post - Adding jpegs to Excel
View Single Post
Old 22nd Jan 2018, 22:23
  #4 (permalink)  
G0ULI
 
Join Date: Dec 2013
Location: Norfolk
Age: 68
Posts: 1
Likes: 0
Received 0 Likes on 0 Posts
This is the sort of job that should be performed using an Access database. Excel is not the right tool for the job!

I can understand why you might be tempted to use Excel but it really is an abuse of a spreadsheet program which will lead to problems in the future. With anything more than a very few images the file sizes will become enormous very quickly indeed. Then you will have issues over the time it takes to retrieve records and load and save updates.

Use a database such as Access. This will also allow for screen layouts to be designed to replicate a spreadsheet with an option to select an image by clicking on a button, or to display a small thumbnail with the record. Exactly what you seem to want.
G0ULI is offline