Thanks, JMay, that looks like good advice. I am able to
import my worksheet into Access with no problem. I am
attempting to do this from Excel and visit Access only
every so often. All the books that I have read so far (Pwr
Prog w. VBA, etc) have not been helpful in this area. Any
other thoughts or pointers on this obsticle? Thanks in
advance.

-----Original Message-----
Start with Access and either Import or Link your data to
a Table.

"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.
.