can Access 2002 or 03 import multiple worksheets?

[Kevin]

Title says it all: I have an Excel spreadsheet with a number of
worksheets. Can Access import them, and if so, what is the earliest
version that will do so, and what are the constraints?

[polite person]

On Sat, 30 Jul 2005 02:49:42 GMT, "Kevin" <ke****@sonic.net> wrote:

Title says it all: I have an Excel spreadsheet with a number of
worksheets. Can Access import them, and if so, what is the earliest
version that will do so, and what are the constraints?

look at
http://office.microsoft.com/en-us/as...950951033.aspx
"Import, export, and link data between Access and Excel"
for a general summary and other refs.

The easiest way might be to set up links to each of the worksheets if this isn't
a one-off import.

As far as I know all versions of Access can do this.

[pietlinden]

Try this link:
http://www.mvps.org/access/general/gen0008.htm