Import data from, but I only want about 6 columns of the 80 columns that have data.

As you have stated that you are not using VBA then I am assuming you are using External Data on the ribbon.

When you choose "New Data Source", From File, Excel and choosing the file that you want to import, the Import Wizard is loaded.

The first thing you must do is choose the specific sheet that the data is on (this may be skipped if there is only one sheet in the workbook). Then press Next >

The next section allows you to tell Access whether or not the worksheet contains Column Headings in the first row. I can't help you there because I don't know what is in your spreadsheet. You may get an error message at this stage

Quote:

The first row contains some data that can't be used for valid Access field names. In these cases, the wizard will automatically assign valid field names.

Just click Ok to this message. Now press Next >

This is the important bit. In this section you get to decide what the Fieldnames are going to be, what the Data Type of each field will be, whether or not the field should be indexed and … whether or not to import the field (column)

Highlight each of the columns you do not want to import and tick the box next to "Do not import field (Skip)"

Now press Next >

The next section allows you to decide whether or not to have Access add a primary key, or you can choose a specific column for the primary key, or you can have none.

Now press Next >

Choose the name of the table you are importing into (assuming you were importing to a new table from the start of this process)

Now press Finish

If you like you can save these import steps if it is a file you are likely to load often.


Alternatively of course, you could always copy the columns you do want into another sheet and import that as-is.