Go to Import and Export (DTS) wizard through strat menu which is always placed with sql200.
First thing you should remember is you have to give two thingd.;
1 datbase source (From what to copy)
2 Destination (where to copy)
Using DTS you can copy tables from access to acess,sql,notep ad and so on....In same way from other database to other or same.
Step first.
Give the data source of dastination....
User Profile
Collapse
-
As you have already said you want to check of 6 digit to 13 so this code does not check that but checks to show XXX
[CODE=vb]
A = Text1.Text
LENA = Len(A)
C = Right(A, 4)
For I = 1 To LENA - 4
D = D & "x"
Next
E = D & C
Label1.Caption = E
[/CODE]Last edited by Killer42; Jan 1 '08, 12:39 PM.Leave a comment:
-
If you want to use multiple check boxes then first be sure you are using a control array. After that while inserting data take this reference.
If you have 11 controls then
Let check box name be check1
[CODE=vb]
For I = 0 To 10
STRA = STRA & "'" & Check1(I).Capti on & "'" & ","
Next
STRA = Mid(STRA, 1, Len(STRA) - 1)
STRSQL = "INSERT...Last edited by Killer42; Dec 31 '07, 08:35 AM.Leave a comment:
No activity results to display
Show More
Leave a comment: