Coding Thread, Read xls or csv into VB and search for a record. in Coding and Web Development; Hi,
We have a excel file containing the schools assets and would like to create a program in visual studio ...
30th April 2012, 11:10 AM #1
Read xls or csv into VB and search for a record.
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.
30th April 2012, 11:17 AM #2
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?
Originally Posted by dany2010
30th April 2012, 11:42 AM #3
Yeah, trying to block everything from being copied, printed, and edited if i can.
28th May 2012, 02:07 PM #4
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.
28th May 2012, 02:35 PM #5
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.
28th May 2012, 02:38 PM #6
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.
By kennysarmy in forum Educational Software
Last Post: 13th January 2011, 08:55 AM
By box_l in forum Scripts
Last Post: 10th February 2009, 09:08 AM
By sradams1977 in forum Scripts
Last Post: 29th December 2007, 10:53 PM
By MK-2 in forum ICT KS3 SATS Tests
Last Post: 24th January 2007, 01:30 PM
By contink in forum Comments and Suggestions
Last Post: 6th July 2006, 02:07 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)