N
Norman
I have a problem when using the Import Spreadsheet Wizard
to import data from an Excel worksheet into Access.
- Open database in Access. Select File, Get External
Data, Import
- Browse for file, type Microsoft Excel. Import.
- Import Spreadsheet Wizard starts. Select worksheet.
Next.
- Tick First Row Contains Column Headings. Next.
- Select In a New Table. Next.
- PROBLEM: Can only alter the first column.
I can select the other columns, but nothing happens in the
box above. Basically, I don't want to import selected
columns, but it won't work!
I'm running Office XP and Windows 2000.
to import data from an Excel worksheet into Access.
- Open database in Access. Select File, Get External
Data, Import
- Browse for file, type Microsoft Excel. Import.
- Import Spreadsheet Wizard starts. Select worksheet.
Next.
- Tick First Row Contains Column Headings. Next.
- Select In a New Table. Next.
- PROBLEM: Can only alter the first column.
I can select the other columns, but nothing happens in the
box above. Basically, I don't want to import selected
columns, but it won't work!
I'm running Office XP and Windows 2000.