ADO help!!!

[Anish S]

1. How can i create a database programatically using ado?

2. How can i determine the no of tables in a database programatically?

3.How can i determine the no of sheets present in a excel sheet programatically?

Expecting positive and quick reply
regards
anish

[bayram]

Hi there! I think you'd better have a look at MSDN library help for more detail information, however, the outline of using ADO object from your code as follows:

1) firstly create an ADO object;
2) then using EXECUTE method execute sql query against a database that creates a db.

Best regards,
Bayram.

[Anish S]

But how do i create a database (an access 2000 database) programatically??

[bayram]

for example:
CREATE DATABASE 'C:\myFolder\myDatabase'

Bayram.

[Anish S]

but how could i create a connection string for the connection object

plz do give me some code

[bayram]

a connection string should look like:
"Provider=MSDASQL;Driver=Microsoft dBase Driver (*.dbf);SERVER=myServer; UID=myUser;PWD=myPwd;Database=myDatabase; DEFAULTDIR=C:\\myFolder"

Bayram.