How to upload multiple Excel 2007 files to SQL Server 2005

If you are here, then you are probably encountering the following:

  • SQL Server 2005 Import/Export wizard is not recognizing your Excel 2007 (xlsx) file(s)
  • You have many files that you need to upload and can’t afford to do them one by one
The good news is that you don’t have to.  Also, this post applies to Excel 97-2003 files, text files and anything else you can upload to SQL Server 2005.  I figured I would begin with one of the more difficult approaches and anything simpler can be deduced from these steps.  For this post, I am using a lot of images and few words.  If you have any questions, please leave a comment.
Also, to accomplish the entire task, you will need a version of SQL Server 2005 (or later) and SQL Server Business Intelligence Development Studio (BIDS).  If you have SQL Server Express, you can download BIDS from Microsoft here.
The process is going to be simple.
  1. Use the Import/Export Wizard to import data and save the SSIS package to your computer.
  2. Open up BIDS and modify your SSIS package.
  3. Run your SSIS package.

This slideshow requires JavaScript.

Below is a narrative for each picture.

Leave a comment

Filed under Computer - Technical, SQL

Comments are closed.