By sclward - 1/31/2010
I'm wanting to export an Excel worksheet to an existing Access table. I want to do this from within Excel using VBA and a user macro. I want to be able to append the existing records within the Access table. What's the best way to do this? Thanks.
|
By sclward - 2/4/2010
Thanks for the response. Seems we have a problem at a certain area while compiling. It does not like the Dim statement as far as Dim db As Database, rs As Recordset. Any ideas?
|
|