Opening Access from Excel

[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

 

[Ron de Bruin]

Check out this site Cindy
http://www.erlandsendata.no/english/index.php?t=envbadac

 

[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

 

[Ron de Bruin]

Hi cindy

Rename your table
Remove the spaces in your table name

 

[Cindy]

Hi Ron,

Thanks so much - it works! You're the greatest. Have a
nice day.

Cindy