Search results

All help is very much appreciated! The more I think about it, going directly from the design software into access worries me. Excel was always a tool we used to double and triple check the designers work. Not all purchased items are included in the design assemblies (ie. cables, pneumatic...

Minty, Solidworks is the software the designers use. You can directly export the Bill of Materials from each sub-assembly into excel files. They then create an compiled BOM excel file which includes a sheet for each Sub-assembly. This is then used during the assembly process. I wanted to add two...

Also, I should add, that leaving everything in excel leaves us with the current problem where all the data is saved in so many different places/files that it creates major tracking issues for the managers, designers and purchasers. Without getting too in detail with our company process, we have...

Thanks Plog, I definitely thought about that but the reason that excel is used is because our design software exports excel files. And there is quite a bit of cleaning up and formatting that needs to be done before it can be added to the database. Also, the designers use excel for other parts of...

Hi, Thanks in advance for help any of you could provide! To start off, I am fairly new to Access but have been working with Excel for years. I am also a mechanical engineer so problem solving is right up my alley! The issue I have is that I want to create an Access database from multiple excel...