Automation of Excel through Vb.net
-
hi i m in deep trouble. Is there anybody who can guide me , how to use excel as a backend database for my project. Mian Rashed Inam Khattak
-
hi i m in deep trouble. Is there anybody who can guide me , how to use excel as a backend database for my project. Mian Rashed Inam Khattak
I don't know if I can help at all, but as far as I know using Excel as a database isn't possible, not in the truest sense. You can write to and from Excel spreadsheets, the data is access by accessing the file, not by using it as a database backend. I've never seen a usage of connecting to data in excel like a database would. You'll need to use Access or even Sequel Server for something like that. I have some code for writing to Excel spreadsheets. It is written in LotusScript but if you know VBScript or VB you shouldn't have any problems following it. You can also look on http://msdn.microsoft.com/ for help as well on the capabilities of Excel. http://skylab.ironclads.com/codes.nsf Good Luck! :) <<<<TIM>>>>
-
I don't know if I can help at all, but as far as I know using Excel as a database isn't possible, not in the truest sense. You can write to and from Excel spreadsheets, the data is access by accessing the file, not by using it as a database backend. I've never seen a usage of connecting to data in excel like a database would. You'll need to use Access or even Sequel Server for something like that. I have some code for writing to Excel spreadsheets. It is written in LotusScript but if you know VBScript or VB you shouldn't have any problems following it. You can also look on http://msdn.microsoft.com/ for help as well on the capabilities of Excel. http://skylab.ironclads.com/codes.nsf Good Luck! :) <<<<TIM>>>>
thanks for the help. i know exactly what you have said, but the problem is that my datasources are excel sheets. and one again thanks for the help. Mian Rashed Inam Khattak
-
thanks for the help. i know exactly what you have said, but the problem is that my datasources are excel sheets. and one again thanks for the help. Mian Rashed Inam Khattak
my actual problem was how to connect excel worksheet(existing) to vb.net. i mean what driver and else..... Mian Rashed Inam Khattak