Recent content by aquila87

  1. A

    merge Columns

    Dear Access gurus :) I have a similar problem with Access (I'm new for using it) - I have exported an excel sheet into Access, which I need to make as a report. The information in Excel file is: first 60 rows merged cells with text, after that 5 rows table and another 20 rows with merged cells...
  2. A

    Import excel table in Access

    I have tried with: Public Function GetMyFile() As Boolean On Error Resume Next Dim fdFilePick As FileDialog Dim varSelectedFile As Variant Dim strInFile As String 'Dim strMyTableName As String Set fdFilePick = Application.FileDialog(msoFileDialogFilePicker) DoCmd.Hourglass False With fdFilePick...
  3. A

    Import Excel into Access Table

    Hi, I have tried the code, but it's not working for me :( It doesn't show me the error or something, but when I click on the button - nothing happen.
  4. A

    Import excel table in Access

    I have this code for importing the excel data into another excel sheet, now I need it to be into access: Private Sub Command29_DblClick(Cancel As Integer) On Error GoTo errorhandler Dim ThisWorkbook As Workbook Dim ws As Worksheet Dim RngFleetData, rng As Range Dim x As Variant...
  5. A

    Import excel table in Access

    Dear All, I really new to VBA and have a big big problem :( :banghead::banghead::banghead: I need to import excel data from sheet1 to access database9. I need it as a button in access, when you push it the data from the sheet1 to uploaded it automatically. If somebody has any idea which can...
See more
Top Bottom