Thread: Excel Export to Access via VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joel[_955_] joel[_955_] is offline
external usenet poster
  
Posts: 1
Default Excel Export to Access via VBA

You are using the ADO method (ActiveX Data Object). You need to add two
references to your VBA from menu tools - Reference

1) Microsoft Access 120.0 Library Object (or latest on your PC)
2) Microsoft ActiveX Data Object 2.8 library (or latest on your PC)


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=199279

http://www.thecodecage.com/forumz

Reply With QuoteReply With Quote