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: http://www.edugeek.net/forums/coding/29608-papercut-print-logger-free-edition-log-distiller-asp-page.html even in VBS you can use a DB adapter to get sorting and querying.