PDA

View Full Version : from excel to database



cheikhanio
02-12-2008, 09:38 PM
please
I to fill out my table in my data base which is carried by (sql server) with a table exist in Excel?
plz help me

Barbarossa
02-13-2008, 10:15 AM
Microsoft SQL Server comes with something called Data Transformation Services (DTS) Import/Export Wizard.

This will do what you want.

cheikhanio
02-13-2008, 03:53 PM
thinkh u very match
Barbarossa (http://filesharingtalk.com/vb3/../members/barbarossa-5)

Askana
02-23-2008, 05:19 AM
if u want to populate records in excel from SQL server u can link the Excel sheet to the Server and download the required columns and tables.