can we create table in SQL server or Ms Access using VB 6.0?
Visual Basic
2
Posts
2
Posters
0
Views
1
Watching
-
Hi Everyone, I have one query in VB 6.0, My query is " can we create table in SQl Server or Ms Acsess using VB 6.0 ? " If yes then, how ist possible ?
Yes, but if the table will already exists you will get an error. you can create table as: Dim cn as new Connection cn.ConnectionString ="Connectionstring" cn.open cn.Execute("CREATE TABLE tNewTable( Field1 Int NOT NULL , Field2 Int NOT NULL )") Regards, Javed -- modified at 0:37 Monday 27th February, 2006