Post reply

Data From Excel To MS-SQL

  • August 27, 2010 at 12:20 am

    #228370

    Hi Frnds,

    Can u guide me, how to insert the data's from excel sheet to a table in ms sql 2005 ?

    For Eg : I am having excel sheets containing 15rows, i want insert those into a table named TABLE_A.

    Thanks in advance

  • August 27, 2010 at 12:30 am

    #1212756

    use:

    1. SSIS

    2. Import/Export Tool

    3. Tsql

    right click any database, tasks, Import data...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • August 27, 2010 at 4:34 am

    #1212838

    You can use BULK INSERT to import excel file into SQL Server table.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply