Hi guys, is it possible to have VBA code that can merge cells in excel before clicking on the import button? As i would like to merge three cells in my excel file into one cell and when i click on import button on my access form, the imported file will only show as one cell instead of three cells.
Below is the code for my import button in vba access
Private Sub cmdImport_Click()
Dim filepath As String
filepath = "C:\Users\Users\Desktop\FabricPODatasheet.xlsx"
DoCmd.TransferSpreadsheet acImport, , "FabricPO", filepath, True
End Sub
Thank you.
Below is the code for my import button in vba access
Private Sub cmdImport_Click()
Dim filepath As String
filepath = "C:\Users\Users\Desktop\FabricPODatasheet.xlsx"
DoCmd.TransferSpreadsheet acImport, , "FabricPO", filepath, True
End Sub
Thank you.
Last edited: