merging multiple excel sheets into access

**simpson** · 10-04-2011, 03:27 PM

I have some great excel spread sheets I have created with the help of the excel forum. Alone the are sufficient for our business to function but I think they would be far more useful if they were combined in an access program.
I have looked through all of the samples and dont think any of them match exactly what I would like to do.
It mainly consists of creating an order, comparing pricing, and creating and invoice. all of the information needed is already on the 3-4 seporate sheets.
Can anyone guide me on where to begin?
thanks in advance

**alansidman** · 10-04-2011, 10:08 PM

I think that you need to understand that Access is a relational database and not an advanced spreadsheet. Having said that, you need to understand that how it works is very different and its application is not as intuitive as Excel. I would start by laying out on paper a schema of what I hoped to accomplish. Set up your tables and how they relate if at all to each other. What you want to accomplish.

Look at this site for information on the fundamentals of relational databases. I hope that you do have a need for Access and you can make it work for you.

http://www.deeptraining.com/litwin/d...aseDesign.aspx

Alan

**simpson** · 11-11-2011, 07:36 PM

What I would like to do is be able to imput data into the specific areas on each created table and have several other tables draw information from those tables to assist my order processing decisions.
ie....
Tables;
trucks, drivrs, locations, prices, freight, terminals
create a load, driver pay, dispatch, summery

most of these are form sheets.
sound like a good Access problem?

**davegugg** · 11-16-2011, 11:04 AM

I think it sounds like Access would be a great tool for you. As Alansidman said, you need to gain a good understanding of relational databases, and Access in particular. Access stores the data more efficiently in tables, and you need to set up forms to change that data. You should try searching Google for beginner Access tutorials, then take a look at the link Alan posted, and the link in my signature. Good luck!