AutoCAD pdf table conversion

boehm330

New Member
Joined
Feb 20, 2012
Messages
13
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
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
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...
 
Upvote 0

Forum statistics

Threads
1,224,222
Messages
6,177,234
Members
452,765
Latest member
Erka Gizli

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top