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.
The process is going to be simple.
- Use the Import/Export Wizard to import data and save the SSIS package to your computer.
- Open up BIDS and modify your SSIS package.
- Run your SSIS package.
Below is a narrative for each picture.