Hi all
i want to use Ms Excel as database and vb6 as front end
is it possible?
if yes then how to do it
plz answer if u know
Pgmer 50 Master Poster Featured Poster
QVeen72 104 Posting Shark
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
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.