Complex VBScript/SQL Script

March 5, 2009 at 11:30:48
Specs: Windows XP

I'm in need of a VBScript and/or SQL Script that will complete the following:

There is a text file with an Account # at a specific location (this location never changes). There is also a SQL Database with a table containing Account #'s, Addresses, etc... What I am looking for is a script (preferably all in VBScript) that will look at the specific location of the Account # in the Text file and if it matches any of the Account #'s in the Database it will automatically populate the address associated with that Account # from the Database into the text file in a specific location. This seems pretty complex, but I was hoping somebody can help me with this?

Thank you!

See More: Complex VBScript/SQL Script

Report •

March 6, 2009 at 01:48:02
It's also a pretty vague description. What type of database? What's the database's name? What validation is required to get into the database? What table are you looking up? What's this table's structure? What's the format of the flat file? What's the path of the flat file? Is there a difference in how the account numbers are represented between the flat file and the database? How should the output be formatted?

The only specific you gave was the language, which seems like an odd focal point, honestly.

Report •
Related Solutions

Ask Question