September 6, 2008 12:45pm pdt

Member Login

Hall of Fame

Yearly

1chapmandew 2,085,990
2angelIII 1,432,487
3aneeshatti... 513,981
4mark_wills 473,916
5ee_rlee 315,195
6brejk 226,005
7dtodd 209,505
8acperkins 186,813
9momi_sa... 185,979
10rickchild 172,740
11BrandonG... 171,234
12ptjcb 160,219
13Thomasian 155,142
14EugeneZ 151,550
15sbagireddi 138,982
16dportas 130,015
17ScottPletc... 124,587
18bashka_... 117,439
19jgv 117,421
20appari 114,979
21PedroCGD 114,120
22PFrog 113,160
23chrismc 112,389
24DanielWilson 110,274
25tedbilly 107,990

	[x] Attachment Details

How to Import from Excel 2007 Using SQL Server Import and Export Wizard

Zone: SQL Server 2005

Tags: Opening a rowset for "`'March Files$'`" failed. Check that the object exists in the database.

I am using SQL Server 2005 and trying to import data from an Excel 2007 file into my SQL Server database. Previously, when importing from Excel 2003 it was very simple (just specify Microsoft Excel as the Data Source and Excel Version of "Microsoft Excel 97-2005". Since there is not an option for version 2007, I have tried to import from Excel 2007 by specifying the following:

Data Source: Microsoft Office 12.0 Access Database Engine OLE DB Provider
clicking on Properties and entering the file path into the "Data Source" textbox on the "Connection" tab for Data Link Properties and then typing in a value of "Excel 12.0" for the Extended Properties on the "All" tab.

The test connection succeeds and I continue in the wizard and specify the database destination etc. I can even view the data using "Preview" but when I run the package, I get the following error:

Opening a rowset for "`'March Files$'`" failed. Check that the object exists in the database.

"March Files" is the name of the worksheet in the Excel file I am trying to import data from.

I need to know what I must do to successfully import data from an Excel 2007 file into SQL Server 2005 using the SQL Server Import and Export Wizard either by fixing the above error or finding some sort of plug in or work around to easily import. I am assuming that Microsoft hasn't updated the Wizard to more easily import from Excel 2007 files?

Start your free trial to view this solution

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.4

Question Stats

Zone: Microsoft

Question Asked By: qryz

Solution Provided By: rlistenb

Participating Experts: 1

Solution Grade: B

Translate:

Loading Advertisement...

20080723-EE-VQP-34 / EE_QW_2_20070628