In a nutshell, it comes down to Access vs. Excel.
So heres what Im doing, I am trying to extract attribute data out of all the blocks in a drawing, to build a BOM that includes the standard stuff, cost, description, manhours to install, etc. I currently have a working solution in excel, but I had a bit of a problem last week. I replaced all the "test" data with real data, and all the formulas and lookup tables just quit working. Thats it, just quit working.
I spent the better part of 2 days trying to get a lookup table to start working. I even tried creating a brand new file, and writing the look up from scratch. Well eventually, it started working again. I dont know why, it just did. :ugly:
So I got to thinking, maybe excel isn't the best tool to be using here. But here is the problem, I dont know anything about Access and VBA connections to Autocad. ADO vs. DAO, what does that mean? Which should I use, and why? And then, I have questions about how I should access my data, and if it can even be done. Plus, how do I get a report out of Access?
These are the things I am turning to you guys for some guidance. Im lost.....