new guy

[Guest]

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

 

[Jason]

This is kind of a backwards solution, but like you, I
haven't figured out any better way. Make an "import" tab
in your spreadsheet containing only columns A and H from
the existing spreadsheet, then import this new tab of the
spreadsheet to Access.

 

[Jason]

Let me clarify that - make the new "import" tab LINKED to
the existing data you want to import. That way, the data
in the proper form to be imported to Access will be
updated automatically when you update the source.