AutoCAD pdf table conversion

[boehm330]

Hi all,

End objective: I'm generating an access database right now and want to import information off of a pdf and have it import all applicable data into a table I've created in Access. This will save me hours and hours of copying data.

Problem: The pdf was generated from AutoCAD, and when I convert to a spreadsheet, numerous cells are merged. I've been trying to come up with a logic statement to build a new concise table, and skip all blank cells. If I need to clarify this let me know. I'll attach a picture so you can see what I'm working with.



Any help or ideas will be greatly appreciated, or if you have a completely different idea of how to get the data from the pdf into access, that works too!

Thanks, Josh

 

[boehm330]

I made a table that returns either the cell value if it contains text, or a 0. Stuck now though, I have a huge table with basically 0's as place holders, but they are necessary since they maintain everything lined up with the applicable heading.

This is what the conversion table looks like...