Export Worksheet to Access
 

Or if you don't like the suggestions these guys have given, you could
explore using ADO to move your data between Excel and Access, especially if
you are wanting to control everything from Excel instead of Access. ADO is
pretty easy to work with, generally speaking, but it takes a little getting
used to. Fortunately, there is plenty of info available.
--

RMC,CPA

"Sigmund" wrote in message
...
Does anyone have a simple VBA function to export a
worksheet into an Access table? The macro recoder does not
want to cooperate in 2k.

Export Worksheet to Access
 

Well, to begin with, there is an ADO newsgroup. Lots of detailed help is
available there. Also, there is quite a bit of info in the KB. Beyond that,
there are numerous books. I have 2 of the Wrox books on ADO and Access
Programming that are both great. I have used ADO with both Office 2K and
Office XP (2002).
--
RMC,CPA


"Sigmund" wrote in message
...
Thanks, RMC, I have checked into ADO only a little bit and
didn't make any headway with it yet. I will check into it
further. Is ADO more useful in 2002 or also in 97/2000?
Any good sources, off-hand, that you might know of?


-----Original Message-----
Or if you don't like the suggestions these guys have
given, you could
explore using ADO to move your data between Excel and
Access, especially if
you are wanting to control everything from Excel instead
of Access. ADO is
pretty easy to work with, generally speaking, but it
takes a little getting
used to. Fortunately, there is plenty of info available.
--

RMC,CPA

"Sigmund" wrote in message
...
Does anyone have a simple VBA function to export a
worksheet into an Access table? The macro recoder does not
want to cooperate in 2k.


.

Export Worksheet to Access
 

That is great! Thank you very much. I will check into it.

-----Original Message-----
Well, to begin with, there is an ADO newsgroup. Lots of
detailed help is
available there. Also, there is quite a bit of info in
the KB. Beyond that,
there are numerous books. I have 2 of the Wrox books on
ADO and Access
Programming that are both great. I have used ADO with
both Office 2K and
Office XP (2002).
--
RMC,CPA


"Sigmund" wrote in message
...
Thanks, RMC, I have checked into ADO only a little bit and
didn't make any headway with it yet. I will check into it
further. Is ADO more useful in 2002 or also in 97/2000?
Any good sources, off-hand, that you might know of?


-----Original Message-----
Or if you don't like the suggestions these guys have
given, you could
explore using ADO to move your data between Excel and
Access, especially if
you are wanting to control everything from Excel instead
of Access. ADO is
pretty easy to work with, generally speaking, but it
takes a little getting
used to. Fortunately, there is plenty of info available.
--

RMC,CPA

"Sigmund" wrote in message
...
Does anyone have a simple VBA function to export a
worksheet into an Access table? The macro recoder does
not
want to cooperate in 2k.


.



.