View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tony
 
Posts: n/a
Default importing from a database?

Hi
im a builder and i use word with an excel insert to create my invoices.
The excel sheet is added over the top of my letter and is used for itemising
the bill.
For example it would list materials, days of labour, plant hire etc. and the
relevant prices, with a total at the bottom.
Quite straightforward.
At the moment when im working in excel, creating the invoice, i just insert
the materials and prices as im going along, every time typing in an item,
checking what the correct price is, typing it in and working down the list.
What i would like to do is build up a database of materials/items and their
respective unit prices.
Then every time i do an invoice i could import this data across with a
single click!!
Ive had access mentioned to me and ive tried to find a simple solution with
the aid of help files etc...but it all seems so complicated!!
Could anyone point me in the right direction!!!

any help greatly appreciated.......Tony