Harold, See my reply to Volunteer. You don't happen to be on Oregon do you? Part of the answer is to export the data from Excel and import it into Access. You have to choose the delimiters when exporting. Tabs usually work fine. Dick
--- In [email protected], "Harold Williams" <[EMAIL PROTECTED]> wrote: > > I have been using excel to do a weekly database for a logging company. > Each week I deal with 2 or 3 crews that harvest timber on 2 to 4 > different tracts of timber. I have 9 columns that I enter data into > either manually or by macro or formulas. I am dealing with loads of > timber that are harvested and hauled to a mill for processing. In my > database I enter the Date, Destination or Mill, the Mill ticket > number, the tract of timber that the timber was harvested from, The > product or type of timber hauled, the volume in tons for each load, > the price that the mill pays for that product per ton, the total paid > for the load of timber, and the name of the truck driver. > > I have recently bought access 2000 and would like to start to convert > to access so that I could retrieve data more easily. I have used > access a little in the past. So I am familiar with the program. My > problem is the best way to set up the tables for the long haul. > > Each mill doesn't process all the products that I deal with. Different > mills process different types of timber. They have a price that they > will pay for those types. This price will go up and down as the market > fluctuates. > > Finally, my question. Do I need to set up a table for all the products > that I deal with, another that lists the mills, and another table for > the prices or could they be combined into one or two tables? I would > like to be able to enter the mill name, the product name, and the > volume and have the price paid entered automatically based on those > entries. I will also need to multiply the volume times the price but > right now I want to try and set up the tables the best way and not > have to re-do them later > > I know this is long but I would appreciate anyone pointing me in the > right direction. > > Thanks > Harold >
