problem importing from Excel - please help

  • Thread starter Thread starter David Wakelin
  • Start date Start date
D

David Wakelin

When I import data from an Excel 2003 spreadsheet into a
new Access 2003 table using File,Get External Data, Import
the wizard will not let me specify any field options
except for the first column. You can click on other
columns but the changes are still applied to column 1.
This works OK in Office 2002
 
This is a programming flaw. Just skip this screen and let Access import the entire spreadsheet "as is". Then open the table. Switch to Design View to delete or rename columns and edit the "indexed" setting. Alternatively, you can also edit the columns in the original spreadsheet before importing

----- David Wakelin wrote: ----

When I import data from an Excel 2003 spreadsheet into a
new Access 2003 table using File,Get External Data, Import
the wizard will not let me specify any field options
except for the first column. You can click on other
columns but the changes are still applied to column 1
This works OK in Office 200
 
Back
Top