Generic? There are so many drivers out there. Are you trying to open an Excel File, Text File, AccessDB, Oracle, MySQL, SQL, or Oracle? If you know what data source you are going after, that would help. That is the beauty of the ODBCxx() UDFs provided here. That way, you don't have to have a ton of code.
{Edit}
Quote:
That way if I'm working on a large project and want it to not be limited to one DB or another, I don't have to provide a bunch of different code for all of the different SQL statements I'd have to write?
I re-read your question.. I think you are looking for a DTS Package that when there is a change in a SQL table, it updates data on other systems. You will want to do that and is very powerful.
{/Edit}
Kent
Edited by kdyer (2006-04-26 11:39 PM)
