+ Post New Thread
Results 1 to 6 of 6
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 ...
  1. #1

    Join Date
    Nov 2011
    Posts
    628
    Thank Post
    87
    Thanked 21 Times in 19 Posts
    Rep Power
    10

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

    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.

  2. #2

    Steve21's Avatar
    Join Date
    Feb 2011
    Location
    Swindon
    Posts
    2,696
    Thank Post
    335
    Thanked 515 Times in 483 Posts
    Rep Power
    179
    Quote Originally Posted by dany2010 View Post
    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

  3. #3

    Join Date
    Nov 2011
    Posts
    628
    Thank Post
    87
    Thanked 21 Times in 19 Posts
    Rep Power
    10
    Yeah, trying to block everything from being copied, printed, and edited if i can.

  4. #4
    ChrisMoore's Avatar
    Join Date
    Mar 2012
    Location
    Scotland
    Posts
    12
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    6
    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.

  5. #5


    Join Date
    May 2009
    Posts
    3,039
    Thank Post
    269
    Thanked 804 Times in 609 Posts
    Rep Power
    295
    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.

  6. #6

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,174
    Thank Post
    868
    Thanked 2,703 Times in 2,289 Posts
    Blog Entries
    11
    Rep Power
    773
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Sibelius 5 Stand alone or networked version! pros and cons please.
    By kennysarmy in forum Educational Software
    Replies: 13
    Last Post: 13th January 2011, 08:55 AM
  2. arrrrggghh! vbs and quotes
    By box_l in forum Scripts
    Replies: 23
    Last Post: 10th February 2009, 09:08 AM
  3. Replies: 21
    Last Post: 29th December 2007, 10:53 PM
  4. XLS to CSV not working for pupil info
    By MK-2 in forum ICT KS3 SATS Tests
    Replies: 3
    Last Post: 24th January 2007, 01:30 PM
  5. Visitors list and search engine bots
    By contink in forum Comments and Suggestions
    Replies: 5
    Last Post: 6th July 2006, 02:07 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •