+ 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
    607
    Thank Post
    84
    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,686
    Thank Post
    334
    Thanked 513 Times in 481 Posts
    Rep Power
    178
    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
    607
    Thank Post
    84
    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
    5
    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
    2,880
    Thank Post
    258
    Thanked 767 Times in 582 Posts
    Rep Power
    269
    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,000
    Thank Post
    851
    Thanked 2,655 Times in 2,255 Posts
    Blog Entries
    9
    Rep Power
    765
    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
  •