Problem with Excel Import Wizard

  • Thread starter Thread starter lozza_arbin
  • Start date Start date
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.
 
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.
 
Back
Top