M
Mkuria
I have little knowledge of VB but this is what I am trying to accomplish.
I need to automate a process where a user links an excel file on their
machine and then runs an append query to update that data to an already
existing table.
I tried the transferspreadsheet however - because users store files on the
local drive - they would have to select the file location---
the second question is I can create an append query to run using linked file
but I would like to delete the linked file after the append query runs. By
deleting the link - the append query will not work next time.
I have copied Kens code OPen file API as a start but I am not sure how to
add it to the module. The linked file will alway be named - Full Project
Detail
DoCmd.TransferSpreadsheet acLink, 8, "Full Project Detail",
"C:\FolderName|" & ("Select the Excel file"), True, "A:BW"
Any insight on how to approach this issue is really appreciated.
I need to automate a process where a user links an excel file on their
machine and then runs an append query to update that data to an already
existing table.
I tried the transferspreadsheet however - because users store files on the
local drive - they would have to select the file location---
the second question is I can create an append query to run using linked file
but I would like to delete the linked file after the append query runs. By
deleting the link - the append query will not work next time.
I have copied Kens code OPen file API as a start but I am not sure how to
add it to the module. The linked file will alway be named - Full Project
Detail
DoCmd.TransferSpreadsheet acLink, 8, "Full Project Detail",
"C:\FolderName|" & ("Select the Excel file"), True, "A:BW"
Any insight on how to approach this issue is really appreciated.