Free for PREMIUM members
[Webinar] Streamline your web hosting managementRegister Today
Dim strFile As String
Dim strTable As String
Dim blnHasFieldNames As Boolean
' Change this next line to True if the first row in EXCEL worksheet
' has field names
blnHasFieldNames = False
' Replace tablename with the name of the destination table name
strTable = "tablename"
' Change C:\Temp\Temp.xlsx with the full file name and path of the Excel file
strFile = "C:\Temp\Temp.xlsx"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, strTable, strPathFile, blnHasFieldNames
Open in new window
With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.