hello
i have an application where i need to pull in data from the excel worksheet and store it in the database (oracle)
At the first instance i need to open the file. Based on a timer if the file is open then i need to pull in data and update database, if closed i need to open it and then update database. How do i check if a file is open. if it is open then i need to pull in data and update the database.
b) This excel sheet has 2 columns. first column has the currency name and the second column the conversion value. the onversion value changes regularly i need to check for it every 15 seconds. My database has a field which records the conversion value at any given time. How do i insert the right conversion value in the database from the excel sheet.
Help needed urgently
i have an application where i need to pull in data from the excel worksheet and store it in the database (oracle)
At the first instance i need to open the file. Based on a timer if the file is open then i need to pull in data and update database, if closed i need to open it and then update database. How do i check if a file is open. if it is open then i need to pull in data and update the database.
b) This excel sheet has 2 columns. first column has the currency name and the second column the conversion value. the onversion value changes regularly i need to check for it every 15 seconds. My database has a field which records the conversion value at any given time. How do i insert the right conversion value in the database from the excel sheet.
Help needed urgently
