Re: New Database from Excel Data

[Jade Reynolds]

OK, thanks both for the responses, both very helpful.

However I have been thinking about this and I want to simplify as much as possible, as this is purely going to feed a PowerBI dashboard.

Each Workbook, is an inspection sheet and there is static data, and defects

all of the data in the following areas are static, there is 1 cell for each entry

Customer name
Depot name
Inspector name
date of inspection
various test results

The defects can be multiple lines,

So I was thinking of having one table for the static data and 1 for the defects.

But,

How would I set up an ID something like an inspection ID, so one workbook is imported into the database, with an ID of 'Inspection 1' for example and all defects are assigned to 'inspection 1'

we cant have the inspectors assign an ID, as there are many inspectors accross the country populating many of these forms, they are then sent in to main depot where (I am hoping) to set up some method of auto uploading to the DB