Can anyone guide me how to import data from excel file to Microsoft SQL Server? My excel file just have the data, no column name.
Thanks.Use DTS ?|||Use DTS ?
Use DTS !!!|||Use SQL's Data Transformation Services. You can use the Import Wizard, which will walk you through finding your EXCEL file and importing it into an existing / new table in the database.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment