i,m dil involved in learning .net .its really great to know from .net we are able to transfer data from sql server to excel.but im intrested to get the data from the excel to .net could u plz help me?

thanq

Member Avatar for iamthwee

but im intrested to get the data from the excel to .net could u plz help me?

I know .net integrates with excel and word. You need to specify the relevant import library.

However,much easier would be to save your excel file as a csv (comma separated value file) and then read it in as a normal text file.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.