Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    10

    Unanswered: How to import Excel files

    I have data in excel files I want to import it to existing SQL Server database. I can use SQL Server built in import tool but before Importing, the data needs to be validated. What is the best way to do this?

    Thanks
    Last edited by smith000monday; 04-25-07 at 05:27.

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    import it into a temp table, validate it, import to main table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •