VBA module for Excel .xlsx worksheet. Looks up value in SQL tables, based on data in spreadsheet – repost by tiddertodmoc

1. Create the simple MS SQL database with the 2 simple table and data listed at the bottom of these instructions. 2. Open the sample.xlsx file attached. 3. Write a VBA module that, when run, connects… (Budget: $30-$250 USD, Jobs: SQL, Visual Basic, Visual Basic for Applications)


Leave a Reply

Your email address will not be published. Required fields are marked *