You can create a function that will pull the data from Excel, then run your Append query on that pulled data, so no need to do an append query from Access to Excel data, just Access to Access.
I am reading "Integrating Excel and Access" by Schmalz, O'Reilly press (sorry Wrox, but I already have most of your books.) I am finding it extremely helpful in this little explored area.
The Using Micosoft Office, Access, and Excel books by QUE cover these topics as well.
HTH
mmcdonal
|