Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Excel database into Outlook Contacts says "No Named Rang | Excel Discussion (Misc queries) | |||
Problem importing data into sql server database | Excel Discussion (Misc queries) | |||
Importing from access database into multiple spreadsheets | Excel Discussion (Misc queries) | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
.csv file creation for importing into a database | Setting up and Configuration of Excel |