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.
 
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

Similar Threads

Import Spreadsheet Wizard Subscript out of Range 0
2007 Import Error 1
Access-Excel Import Wizard problem 1
How can I import file .xlsx (excel 2007) to Access 2003? 2
Import Problems with Excel 6
Access Import Wizard not working 0
Column headings on an import 6
access import wizard doesn't import all rows of excel file 1

Top