Can't Seem To Use An Excel File As Data Source?

This should be very simple but I'm very new to Visual Studio so I can't get it to work. I want to take data from an excel (2003) file and turn it into a bunch of charts that would be viewable on a webpage that I'm trying to build in Visual Studio .Net 2005 professional.

I can't seem to use an excel file as my data source, here are the steps that I've followed:

1) created a new asp.net project

2) dragged a report viewer from the toolbox and it asks me to choose a report or "Design New Report."

3) Clicked Design New Report, and it opened up a new blank report.

4) Clicked "Add New Data Source" and got the Table Adapter Configuration Wizard.

5) Clicked new connection and it brought up the Add connection table.

6) Clicked "change" under data source and I chose Microsoft ODBC Data Source (not sure if that's right.)

7) Under "Data source specification" I chose "Excel Files"

- The first time I did this it brought up a window for me to choose an excel file so I did. Something along the way failed out but it stilled saved "ConnectionString1" as a connection to that first excel file. Now every time after I choose "Excel Files" and click "OK" the add connection window disappears and it goes back to the Table Adapter Configuration Wizard with the "ConnectionString1" as the connection string. It won't let me specify any different excel file. So I did 1-6 again and picked up at 7B

7B) Instead of using "Use user or system data source name:" I chose "Use connection string:" and clicked Build.

8) Picked the "Machine Data Source" tab and chose "Excel Files" and clicked ok

9) The "Select Workbook" window appears so I went to the file I wanted to use as my data source and click OK

10) Back on the Add Connection window I clicked test connection and it succeeded so I clicked ok.

11) It goes back to the Table Adapter Config Wiz window, but the connection string only says "Dsn=Excel Files"

12) clicked Next, then Next again, then clicked on Query Builder. The Add Table window pops up but there is nothing in there for me to choose from.I've tried a million other things, here are a few of the errors that I seem to get a lot.

[IM006][Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
[HYC00][Microsoft][ODBC Excel Driver] Optional feature not implemented
[HY001][Microsoft][ODBC Excel Driver] Too many fields defined.

Does anyone have any thoughts? Is there a reference I need to add or something?