hows best to go about this ?

Welcome to Old Skool Anthems
The Old Skool Resource. Since 1998.
Join now
D

Danny

Active member
Jul 22, 2002
3,223
5
38
41
London, UK
www.ketoloco.com
my current job at work is build a database containing every settlement in the uk with a population of 4,000+. i have started breaking down the data first in scotland, please see the 2 attached excel spreadsheets - the first shows 1 council which i have broken down into settlements of 4000+, and the other shows that council's various 'wards' and their populations ..... to go with each ward in the excel spreadsheet i have to provide a jpeg image showing the ward clearly (again, example of image supplied) ......

now i'm getting all the info relatively quickly, but the problem i am having is finding what the best way of putting all this info together is? i first used work and put the statistics alongside each image, but this was taking too long to do ..... and since then i have used powerpoint, with an image of each ward being presented on a seperate slide with the data copied next to it ..... the problem being with this is that for each council the powerpoint file will be near on a whopping 5MB, so i cant be sending 1000's of 5mb files to our clients .....

what then is the best proggy to use to put all this together? i can use access but am not fluent in it so it could take a while, but presumably this is the best way of whacking everything together? if so, how do i import images into the database?

cheers for any info :thumbsup: they should be paying you lot for this n'all ;)

Danny :)

edit: cant attach excel spreadsheets on ere :S .... but you get the picture :)
 

Attachments

  • Almond Ward, West Lothian.jpg
    Almond Ward, West Lothian.jpg
    82.2 KB · Views: 74
S

sirius

Registered Member
Dec 28, 2001
5,309
0
0
46
I bet you get a better response, but whats wrong with a PDF of the powerpoint/works? Get a PDf printer like the free PDF995 (i think thats the name) or whatever, and get your stuff together on screen and print it to an electronic document. The good thing about PDF is that the image quality shouldnt be lost, and you can zoom into text/pictures without it going all blobby. Well to some extent :).

May not be what you need, but if its only data they are after and not the actual working powerpoint file to alter themselves, then it may work :S .


We use PDF's all the time at work, where we want to send CAD files to customers and other manufacturers where we wouldnt like them to alter the files or adapt them themselves to cut us out the picture in the future! lol.

errm, doesnt help compiling the data, but might solve the presentation aspect. I dunno.Ideally, you would maybe need to find a way to make professional PDFs with multiple pages etc.

Cheerio

Sirius.
 


Top Bottom