Writing to SQL

[bettman]

Greetings,

I need to write a script which reads the contents of a text file and write that information to a SQL table (on a different machine). Any assistance provided would be appreciated.

[Deana]

I recommend use ADO. There is a nice tutorial that should help get you started: http://techsupt.winbatch.com/webcgi/webbatch.exe?techsupt/tsleft.web+Tutorials/OLE~TUTORIAL+ADO.txt

See also:
http://techsupt.winbatch.com/webcgi/webbatch.exe?techsupt/tsleft.web+WinBatch/OLE~COM~ADO~CDO~ADSI~LDAP/ADO~DAO