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
24 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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
My experience with Windows 10 over a one year period and suggestions for smooth operation
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

896 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now