Pull Data from an excel sheet, based on a textbox contents

Question

Okay, I'm currently writing an Audit program for the company I work for to allow us do Audits easier than our current process.

PROBLEM:

I'm struggling to get or find a way for VB to reference a stock file (Excel, can be converted to txt delimited files etc.) with a barcode(column 1), and pull a code(column 2) and the description(column 3) from it and put that data in two other text boxes.

I'm currently using a Windows Form Application, so C#.

Could someone please point me to an article or explain how to go about this?

If you are using C# then why did you include the VBA category and the vb.net category? — braX, Jun 23 '17 at 13:51

score 0 · Answer 1 · answered Jun 23 '17 at 14:18

0

Option: Connect to the excel via oledb. Reading excel file using OLEDB Data Provider
Option: Convert the excel file to a txt file, and read it with StreamReader.

answered Jun 23 '17 at 14:18

donCalculator

318
1
11

Pull Data from an excel sheet, based on a textbox contents

1 Answers1