Search results

  1. W

    import excel data into existing access table using vba

    Solved, appreciated. I used the below Code: Public Sub ImportExcelSpreadsheet(fileName As String, tableName As String) On Error GoTo BadFormat DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "EmpDoc", fileName, True Exit Sub BadFormat: MsgBox "The file you tried...
  2. W

    import excel data into existing access table using vba

    Private Sub btnImportSpreadsheet_Click() Dim FSO As New FileSystemObject If Nz(Me.txtFileName, "") = "" Then MsgBox "Please select a file!" Exit Sub End If If FSO.FileExists(Nz(Me.txtFileName, "")) Then ExcelImport.ImportExcelSpreadsheet...
  3. W

    import excel data into existing access table using vba

    From external data tab ? I need form that enable me to import data from any formatted excel to existing table in access
  4. W

    import excel data into existing access table using vba

    Hello everyone, I would like to ask you if you have example file to import (append) data from excel to existing access table via vba codes ? Note: the code does not contain a specific Excel name. thank you,
  5. W

    Tables Issues

    @MajP many thanks , @isladogs yes i did thank U :)
  6. W

    Tables Issues

    @June7 thank U
  7. W

    Tables Issues

    @theDBguy appreciated 🙏
  8. W

    Tables Issues

    Hi I have problem with my Ms Access, where there are a number of tables i do not know from where it come from. even when i open a new file or blank template. it appears to me in faded manner. when i want to delete it the below message will be displayed. Any one have solution ?
  9. W

    new one

    thank you all
  10. W

    new one

    Dear All, Great day. My name is Wejdan from KSA. I am new In programming languages, databases and very interested in learning that. Regards,
Top Bottom