Linda

You can either Import it or Link the Excel table (the latter will always
have the up to date data from the Excel worksheet

In Access go to FileExternal data and select import or link. (Be sure to
select Excel from the 'files of type' dropdown in the dialog)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog


"Linda" wrote in message
...
I have my original data in excel format. Can I convert the data in Excel
to
Access as the data base in Access? I know how to export data from Access
to
Excel, but do not know the reverse. Can somebody answer my question?

Thank you,
Linda