Hi!

I want to convert all my excel files in to sql server database.

how can i do this.

please help me out in solving this..

thanks

manjula.

    The task of actually getting data from excel into sql is quite easy. Excel has an export function and sql has a import (LOAD) capability.

    For you though I suspect thesimple moving of data from one to the other may not be the issue.

    One is a spreadsheet that can be used as a (simple) database. The other is a powerful relational database that is anything but a spreadsheet.

    Excel will forgive many stuctural problems with data. SQL will be much less forgiving.

    First step is to review the data in excel - both quality and structure. Clean it all up. 'Normalize' the data so that you can use the power of a DB like SQL better. Once the data is clean and well structure simply 'export' from one and 'import' to the other.

    Cheers,

    Cris

      Hi
      I have done same thing in between excel2000 and msaccess2000.
      in access u just go to file menu, click on getexternal data, import.
      it will ask you from where you want to import. select the excel file and it will ask you whether you want to import in the existing table or want to create new one.
      just try in this way. i think the same should work for sql also.

      Reply back if it works.

      Manjula wrote:

      Hi!

      I want to convert all my excel files in to sql server database.

      how can i do this.

      please help me out in solving this..

      thanks

      manjula.

        5 months later

        Excuse me, but have anyone try to really do that? If it does not work , is there any way to do this other than using BCP? Doing a project like this right now and would like to know? Is it got anything to do with ADO programming??

          a month later

          Hello,

          I have around 200 excel files to be converted in a single SQL Dtabase in a single table. I have to develop a program in VB for this data migration.
          Can U guide me?

          regards,

          Parikshit.

            Write a Reply...