By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,335 Members | 2,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,335 IT Pros & Developers. It's quick & easy.

can Access 2002 or 03 import multiple worksheets?

P: n/a
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?
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Nov 13 '05 #2

P: n/a

This discussion thread is closed

Replies have been disabled for this discussion.