2
Contributors
1
Reply
2
Views
10 Years
Discussion Span
Last Post by QVeen72
0

Hi,

Yes, MS Excel can be used as a Database,
You can connect it with ADO with the following Connection sring:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""


Regards
Veena

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.