Service that loads data from excel\xml to Sql server 2008
$30-250 USD
Cancelled
Posted almost 11 years ago
$30-250 USD
Paid on delivery
the excel file will be in a folder, and the service will take the excel\xml file, loads it into sql server 2008 and put the excel\xml in an archive folder, and adds to file name the date-time of process.
I need that the service will listen to a xml and sql table that will contain the definition:
1. ID, IP, SqlServer, login, Password
This xml will tell the service to what database it should login to
2. ID, Folder Path, Database, Table.
This table will tell the service from which folder to take the file and where to transfer the data (DataBase\Table)
Hi,
I'm an expert SQL developer and can do this job for you. I will develop a Windows service app with Delphi that will listen to the folder for new Excel file and then upload to SQL Server.
Can complete in 2 days.
Bests,
Larry