Problem with Excel Import Wizard


L

lozza_arbin

Hello,
We're having a problem the Excel import wizard in Access 2003 & 2007.
Normally when Importing an Excel file you are given the option of selecting
the Worksheet number, range etc. when you want to import.
For some reason the first page we're getting is the page to select Column
Headings.

We're using Office 2003 SP3 and Office 2007 SP2. I'm importing to a new Table.

However I've run the same test on Office 2007 (no Service Pack, fresh system
build), and it works as I'd expect.

I can't find any information online whey this could be happening. If anyone
could come up with some suggestions I's be grateful.
 
Ad

Advertisements

L

lozza_arbin

Finally worked out where we'd gone wrong.

Although a named range was defined it contained no data. Since there was
only a single worksheet, Access doesn't give you the option of selecting a
Range or a Worksheet. Once a Range is defined correctly, the Import Wizard
works correctly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top