Opening Access from Excel
 

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

Opening Access from Excel
 

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

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Cindy" wrote in message ...
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

Opening Access from Excel
 

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

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

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Cindy" wrote in message
...
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


.

Opening Access from Excel
 

Hi cindy

Rename your table
Remove the spaces in your table name

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Cindy" wrote in message ...
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

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

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Cindy" wrote in message
...
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


.

Opening Access from Excel
 

Hi Ron,

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

Cindy

-----Original Message-----
Hi cindy

Rename your table
Remove the spaces in your table name

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Cindy" wrote in message
...
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

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

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Cindy" wrote in message
...
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


.



.