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!

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.