PHD
asked on
Sql package to import data from Excel 2003 -> Sql server 2000
I made an sql package that import data from Excel file into sql server table.
That package should be launched from a Delphi application.
https://www.experts-exchange.com/questions/21120355/Excel-2003-SQL-server.html
How can I do that ?
That package should be launched from a Delphi application.
https://www.experts-exchange.com/questions/21120355/Excel-2003-SQL-server.html
How can I do that ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
use the dtsrun command prompt utility:
WinExec('cmd /c dtsrun /Sserver_name /Uuser_nName /Ppassword /Npackage_name /Mpackage_password', SW_HIDE);