Forum Discussion

sunilbsrv2k's avatar
sunilbsrv2k
Copper Contributor
Mar 28, 2024

Append Excel data into MS Access though macro

Hi All,   I have a task to automate the process of appending the table in MS Access with the data in an Excel file.   I have created the Excel file, imported the data in Access.   But the task ...
access
office 365
peiyezhu's avatar
peiyezhu
Bronze Contributor
Mar 29, 2024
SQL = "SELECT * INTO " & AccessTable & " FROM [Excel 12.0;Database=" & ExcelFile & "].["
& ExcelTable & "]"
Conn.Execute SQL
  • sunilbsrv2k's avatar
    sunilbsrv2k
    Copper Contributor
    Apr 01, 2024
    Thank You; Let me try this and update you.

Resources