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.