Hi Guys,
I have been trying to search for a free asp or asp.net script that will allow me to upload a .csv file and import it into an MS SQL Database. As its going to be a ProductCatalog and pricing changes nearly 2nd day. And wanting to an a script that I can put in my admin panel on my site to upload a .csv file and import it to a MS SQL Database.
I will be updating fields as well as adding new products. So the upload script would need to be able to handle those two things.
Is their any good free scripts around that people can recommend.
Thanks
Matthew
Which version of SQL server are you using?
SQL Server Integration Services will do this nicely...
|||Using SQL 2005 Standard Edition, as the database will be used on a Website, don't want to have to keep logging into the control panel and then going and using the Web-Based SQL Management Tools.
Matthew
|||Hello,
http://www.nigelrivett.net/ImportTextFiles.html is a script to import text files that arrive in a directory into a table.
It will process every file in the directory with the correct filemask and move the file to an archive directory on completion.
It can be used in conjunction with an ftpget SP to import files from a ftp server .
You could add some minor change to import csv file.
No comments:
Post a Comment