Opening Access from Excel

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

Please help!

I need to take a named range of data in Excel 2000 and
append it to an existing table in an Access 2000 database
programatically.

I've been tried different methods and I can't get it to
work. I read about "ADO Connection" but don't quite get
it.


Thank you

Cindy
 
Thanks Ron,

I copied that code into my Excel module and modified. I
get a runtime error -2147217900 (80040e14) - Syntax error
in from clause for the line of code below:

rs.Open "PDA Request Tracking", cn, adOpenKeyset,
adLockOptimistic, adCmdTable

Any idea what's wrong? "PDA Request Tracking" is the name
of my table. Thanks for your help.

Cindy
 
Back
Top