Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

data migration tools for ecommerce

we have ecommerce website and database selling products on line and we always receive csv/excel file product information for update. We hope to find a tool we can use for data upload / migration for eCommerce purposes. any ideas?
0
ITsolutionWizard
Asked:
ITsolutionWizard
1 Solution
 
Randy PooleCommented:
Normally you would create a custom importation routine either in SQL Server or a web page so it can do exactly what you need it to do.  Add new items, discontinue items, adjust quantity on hand and price. Etc.
0
 
Vikas GargBusiness Intelligence DeveloperCommented:
Hi,

If you have SQL then You can try SSIS package which will load the data from any source to the SQL

IF the CSV / Excel file format will remain same then you can Create SQL query to fetch data from CSV/EXCEL and Load it to the SQL.

select *
into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
    'Excel 8.0;Database=D:\testing.xls;HDR=YES',
    'SELECT * FROM [Sheet1$]')
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now