Word Document Data Extraction to SQL
Budget: ₹1,250 – ₹2,500 INR
I need help moving structured information that currently sits inside a batch of Word files into my SQL database. Every document follows the same template—think headings like Name, Address, Reference ID, Dates, and a few numeric fields—so once you see one you’ll immediately understand the layout of the rest.
The job is pure data extraction from documents. You’ll read each Word file, pull the fields exactly as they appear, and insert them into the SQL tables I’ll provide. I will supply:
• a sample of the Word template
• the SQL schema with column descriptions
• a small set of completed rows so you can confirm formatting
Accuracy is key; any typos or misplaced values will create reporting issues downstream. Please make sure each entry matches the Word source character-for-character (dates can be reformatted to YYYY-MM-DD if needed). A short progress log—document name, rows added, any anomalies—will keep us both on track.
Deliverables are straightforward: an SQL script or CSV ready for import, plus the log file. If you prefer working directly in my staging database (remote credentials supplied on request), that’s fine too.
If you have a routine or a script to speed up extraction, great; if not, careful manual entry works as well. Either way, I will spot-check before final acceptance. Let me know your preferred approach and timeline so we can get rolling.
The job is pure data extraction from documents. You’ll read each Word file, pull the fields exactly as they appear, and insert them into the SQL tables I’ll provide. I will supply:
• a sample of the Word template
• the SQL schema with column descriptions
• a small set of completed rows so you can confirm formatting
Accuracy is key; any typos or misplaced values will create reporting issues downstream. Please make sure each entry matches the Word source character-for-character (dates can be reformatted to YYYY-MM-DD if needed). A short progress log—document name, rows added, any anomalies—will keep us both on track.
Deliverables are straightforward: an SQL script or CSV ready for import, plus the log file. If you prefer working directly in my staging database (remote credentials supplied on request), that’s fine too.
If you have a routine or a script to speed up extraction, great; if not, careful manual entry works as well. Either way, I will spot-check before final acceptance. Let me know your preferred approach and timeline so we can get rolling.