Hello,

From a beginner ......

Problem: Unable to save monthly data from excel spreadsheet(2007) to oracle database(10g) with data types/cell formats. eg: if its a numeric value, the code should recognize as numeric value for the cell and save it in database as a numeric value in the numeric field of the database table. If not, the value should be saved as a text value in the database in the text field of the database table. This should recognize for each cell in the spreadsheet (say for 5 columns where number of rows will depend on the number of days for the month which i have figured out but the data type problem remains)

I am able to do this for a single date but unfortunately not for the entire month.

Any ideas or help will be of great help.

Using ADODB for connecting to DB.
Using macros for the purpose of reading and saving data for the month using ms dtpicker function for dates/month and save/read buttons for saving and reading data.