Search Results - CodeGuru Forums
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: thedeathnotes210x

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    339

    Upload Excel to Access

    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.
    ...
  2. Copy directory from hard disk to textbox

    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...
  3. Replies
    6
    Views
    795

    Re: Insert data = 0

    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...
  4. Replies
    6
    Views
    795

    Re: Insert data = 0

    I have to insert 2 way : if it exist or not.
  5. Replies
    6
    Views
    795

    Insert data = 0

    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....
  6. Data mismatch in criteria expression

    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...
  7. Replies
    1
    Views
    592

    Import 2 tables Access to Excel

    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...
  8. Re: Export Excel to 2 tables Access ??????

    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...
  9. Re: Export Excel to 2 tables Access ??????

    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...
  10. Re: Export Excel to 2 tables Access ??????

    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...
  11. Re: Export Excel to 2 tables Access ??????

    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,...
  12. Re: Export Excel to 2 tables Access ??????

    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 & "', _...
  13. Re: Export Excel to 2 tables Access ??????

    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...
  14. Re: Export Excel to 2 tables Access ??????

    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...
  15. Re: Export Excel to 2 tables Access ??????

    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
    ...
  16. Export Excel to 2 tables Access ??????

    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,...
Results 1 to 16 of 16


Azure Activities Information Page

Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center