Question read excel data

[sweish]

can anyone give sample code to read excel data in vb.net and insert those values into access database?

 

[cjard]

read the DW2 link in my signature, section Creating a Simple Data App for a general overview of database principles; loading and saving data etc

Then visit ConnectionStrings.com - Forgot that connection string? Get it here! for the necessary info to connect to excel as well as access.. Connect to excel, read the data, use a loop to copy it into the datatable associated with the access database and save it