newbie question

[very new guy]

Hello and thanks in advance... I am trying to import an
excel spreadsheet into access. I have figured it all out
so far except for how to eliminate the rows that I want
to eliminate. I can eliminate rows on either side of any
given row but not in between that row. Kind of cryptic I
know, for example A:B I know will give me columns A and B
but I need A and H only...Thanks again

 

[Jim/Chris]

As far as I know you are limited to ranges like A thru H.
Import the excel spreadsheet to a temporary table or linkt
to it and use an append query to add the fields to your
main table.

Jim

 

[Cheryl Fischer]

To get just columns A and H, use the File Import Wizard. On the fourth
screen of the wizard, you will see Field Options. Among these is a text box
labeled "Do not import field (skip)". Below this area, you will see your
fields divided into columns separated by a line. Click in a field/column
that you do not want to import and then put a check in the checkbox. Repeat
for each field/column you want excluded from your import.

hth,