Macro to update data from excel file

[PrasadD]

Hello All, I have some data in the Excel file, and i want to get it into sql table. How can i do that? Can i use macro ? if Yes than how should i use the macro? Thanking in advance. Prasad.

[xoph]

The easiest way to transfer data accross is to create a DTS package: start SQL Enterprise Manager, go to the Data Transformation Services node, right click on "Local Packages" and select "New package". By drag and drop, you can create 2 connections objects, 1 Excel object and 1 SQL Server object (you can create other types of connections as well, including ODBC, csv file, Oracle, Sybase, etc...) Then drag and drop a "Transform Data Task" object, set its source to Excel and its target to SQLServer. Right-click on the "Transform Data Task" object and select properties. You can configure how you want the data to be mapped, it even creates a table in SQL Server if you want. It is quite easy to use, virtually no code to write. Save your package, execute it and you're done. If you want to re-use this package it is quite handy. You can add all sorts of other tasks/macro that run before or after the data pump. You can also specify the order in which each step should be executed. :rolleyes:Chris