2

Current Problem: We have a vendor that provides us with a bill of lading in the form of a word document via email, and we are looking to ingest this information into our SQL Server database. I've done some of this in the past, but it was on more of an ad-hoc basis.

Previously, I created a VBA script in Excel to look at a list of file paths, open each document up, look for a starting range and ending range and copy/paste everything in between and move onto the next file.

This process is something we do on a daily basis, so I was wondering the capabilities of creating a dedicated email address (easy enough), but pulling out the attachment, and ultimately scraping it and ingesting the necessary information into a SQL server table?

Best Regards!

closed as unclear what you're asking by RockPaperLizard Jan 25 at 6:58

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

0

If you can code VBA then Python shouldn't be too much of a challenge (plus, it looks good on your CV ;-)

Have a read of:

Also, consider exporting from Word to another format, which might be easier to parse.

Please come back & let us know what you decide, as I might want to do this one day :-)

Not the answer you're looking for? Browse other questions tagged or ask your own question.