[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

I wanna retrieve data from two worksheets in the .xlsx file by doing join operation on them using olebd c#.wrote the query as (@"select * from [sheet1$] inner join [sheet2] on sheet1.Id = sheet2.id"

Posted on 2016-10-22
2
Medium Priority
?
58 Views
Last Modified: 2016-11-11
But it's giving error "no value passed to one or more required parameters"..
0
Comment
Question by:Susmita Patra
  • 2
2 Comments
 
LVL 35

Accepted Solution

by:
[ fanpages ] earned 2000 total points (awarded by participants)
ID: 41855577
The exact SQL statement needed will depend on how you are opening the connection to the MS-Excel workbook file, certainly depending if you are using the "HDR=Yes" parameter, but I suspect you may need to revise what you have at present to something like this:

SELECT * FROM [Sheet1$] INNER JOIN [Sheet2$] ON [Sheet1$].[Id] = [Sheet2$].[id]
0
 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 41883574
Without further input from the Asker this comment is the 'best' solution.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…

613 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question