Hello world,
First time poster, but visited heaps in the past and I found this forum to be very helpful.
I'm about to set up a new database and would like to get it right from the start. At the moment I'm running a similar database (set up years ago) and this one relies on manual data entry, which is a huge task (I'm getting the data delivered in a PDF file). I'm trying to avoid that this time as the data is delivered in Excel.
Every day I get around 20 emails with Quality Assessment reports (in Excel), so each report is a separate excel file. The information I need is on 1 tab, always in the same cells.
The Quality Assessment Report looks like a form, not a database, which means I need to get data from different cells. My goal is to get all this information into a nice tabular database.
How can I do this? Is it better to do this via Excel or Access (no experience with Access)?
I'm using Excel 2007, Windows 7.
Is there any way that I can attach files, so that you can have a look at what I mean?
Thank you very much!
First time poster, but visited heaps in the past and I found this forum to be very helpful.
I'm about to set up a new database and would like to get it right from the start. At the moment I'm running a similar database (set up years ago) and this one relies on manual data entry, which is a huge task (I'm getting the data delivered in a PDF file). I'm trying to avoid that this time as the data is delivered in Excel.
Every day I get around 20 emails with Quality Assessment reports (in Excel), so each report is a separate excel file. The information I need is on 1 tab, always in the same cells.
The Quality Assessment Report looks like a form, not a database, which means I need to get data from different cells. My goal is to get all this information into a nice tabular database.
How can I do this? Is it better to do this via Excel or Access (no experience with Access)?
I'm using Excel 2007, Windows 7.
Is there any way that I can attach files, so that you can have a look at what I mean?
Thank you very much!