So there are a lot of questions regarding this method on SO, but none seem to answer my question. I firstly had an issue with the connectionstring (although it seems to work in other areas of my code correctly). This was resolved easily.

Now the issue is with a simple SELECT query via a OLEDBCommand (Text) that keeps popping up the following error?

"SELECT [Opportunity#],[BidManager],[Prob %],[Opportunity_Stage].[Opportunity_Status],[Term],[Sign Date] FROM [Sheet1$];"

No value given for one or more required parameters.

but their are no parameters????

Checked and double checked the columns names, but to no avail. Also tried removing the special characters from the column names, but still the same exception.