Hey all,
I want to be able to retrieve data from an excel spreadsheet that is specified by a user (using a browse option which I have already completed) which searches through the spreadsheet referenced, finds the row that starts with the letters "IIN", looks at the rows that follow it (not including the first row itself) then looks until it finds "* refer" and then imports that data into a table in the database called "Parts*" where * = the number in a text field on my form (txt box called txtfile). I realize this is probably a HUGE thing to do, but I am completely lost... any help will be greatly appreciated! Thanks!
I want to be able to retrieve data from an excel spreadsheet that is specified by a user (using a browse option which I have already completed) which searches through the spreadsheet referenced, finds the row that starts with the letters "IIN", looks at the rows that follow it (not including the first row itself) then looks until it finds "* refer" and then imports that data into a table in the database called "Parts*" where * = the number in a text field on my form (txt box called txtfile). I realize this is probably a HUGE thing to do, but I am completely lost... any help will be greatly appreciated! Thanks!
