Read xls or csv into VB and search for a record.

[dany2010]

Hi,

We have a excel file containing the schools assets and would like to create a program in visual studio that can read the file and allow searching for a record. We would like to ba able to search with the assett number and then view all data (columns in the xls file) on that asset.

I have done a few minor things in VB but its been such a long time now.

Does anyone know of a guide or something similar that would help in this?

A database would be easier but we cant change it.

Many thanks.

[Steve21]

Does anyone know of a guide or something similar that would help in this?
.

Any reason you want it in VB? Excel has search/filter options built in, which seems a lot easier way to do it. Or don't you want the backend accessed?

Steve

[dany2010]

Yeah, trying to block everything from being copied, printed, and edited if i can.

[ChrisMoore]

Is this VB.NET ? If so you could use the OleDB adapter for Excel and CSV files, or use a parser like this one.

It will give you an ADO DataSet and DataTable with the CSV data in it so you can show the data in a grid and apply searches or filters.

[pcstru]

You could do it in Excel. Use protection to deny access to the sheets. Pop up a form when the workbook opens. Use the form to offer search.

[SYNACK]

Look at the code in this: Papercut Print Logger Free edition - Log Distiller ASP page even in VBS you can use a DB adapter to get sorting and querying.