Search results

Get the data from Excel to Access. But I think I have figured at least a decent solution for now. The db is at work, so I can't post it until Monday. However, imagine a spreadsheet that has this: Manufacturer | Part # | Description | Qty | Price | Total...

Each time Engineering sends us the quote, it's a different filename. Thus why I can't just link directly to a spreadsheet.

First, let me explain how this works at my company. We use a glorified spreadsheet that goes to engineering. They figure out the systems we're going to install, fill out the parts and labor. Currently, we use a Word template, we cut and paste the labor, hours, and parts from the spreadsheet...