Search:

For Example:

I have database in Access with Table Student (StudentID, StudentName, Address,Telephone).
And Excel file is missing StudentID.
Excel is including :StudentName,Address,Telephone.
...

I am creating 1 textbox and 1 button. A button is open a file contain database (.mdb) and textbox is shown the directory.
Example : C:\ TEST.mdb
I want to copy the directory in the first time and...

Dim diem as Double
If (ws.Range("F" & i).Value = NULL) Then
diem = 0
Else
diem = ws.Range("F" & i).Value
End If

con.Execute "INSERT INTO...

I have to insert 2 way : if it exist or not.

I am trying to use Insert Statement which is one of the field(format = Number) in Access = 0. My program does not understand data which is one of the field = 0. Can you help me to solve the problem....

I am using INSERT statement to execute the program. And the error has occured : "Data mismatch in criteria expression". I am checking my database but I could not find the error. Can you help me to...

2 Tables Access:
SV(ID,MSSV,MaLop,Ho,Ten,HanhKiem)
Lop(MaLop,TenLop)

My Excel file include:

MSSV MaLop TenLop Ho Ten HanhKiem

I want to import data from access to excel.But I do not know...

I have 2 problem in my homework. Firstly, I have convert ID field from AutoNumber to Number. I want to start ID = 1.Because I try to fix it but ID is starting 0. When I insert repeatly the second...

Now I Stuck in FIND Statement because my homework is required if MSSV is update in the first time, the ID Number = 1. Then if MSSV is update the second time, the ID Number = 2 and the Status from...

I can not use UPDATE Statement and I do not know Find Statement is working or not. Because I get the error "Syntax error in UPDATE Statement" .The code is as below:

Dim ex As New Excel.Application...

I am stuck in Find Statement. You can help me using IF Statement.
Example : If MSSV is found, you use INSERT Statement

rs.Open " SELECT * FROM SV where MSSV ='", con, adOpenDynamic,...

con.Execute "INSERT INTO SV(MSSV,MaLop,Ho,Ten,HanhKiem,User,Status,Date) VALUES ( _
'" & ws.Range("A" & i).Value & "', _
'" & ws.Range("B" & i).Value & "', _
'" & ws.Range("D" & i).Value & "', _...

tenUser = tbUser.Text 'the user is logged in
Ngaygiodangnhap = Format(Now(), "dd/mm/yyyy hh:mm:ss AM/PM") 'Ngaygiodangnhap is date/time where the user is logged in
con.Execute "INSERT INTO...

My Excel have just 5 value : MSSV,MaLop,TenLop,Ho,Ten,HanhKiem
My table Access have just 10 value : ID Number, MSSV,MaLop,Ho,Ten,HanhKiem,User,Status,Date.
I am trying to fix INSERT Statement but...

On Error Resume Next
Dim ex As New Excel.Application
Dim wb As Excel.Workbook
Dim ws As Excel.Worksheet
Dim i As Long: i = 1
Dim con As New ADODB.Connection
Dim con1 As New ADODB.Connection
...

I have a problem about INSERT INTO with 2 tables access.
My Excel file have a few paramater : StudentID, ClassID,ClassName,FirstName,LastName
My Access have 4 tables : Student, Class,...