Importing a spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that I would like to import into
Access. The spreadseet can be of variable length...so,
this is what I have to do...

Search for work "Account" in the excel sheet
Once account is located, delete 2 rows ahead and two rows
behind.

How do I code this ?

Thanks
 
Why not import the whole spreasheet and run a delete query
base on the field with "Account" in it. delete if null.

Or link to the spreadsheet and run an append query to a
different table based on the field with the value "Account"

Jim
 
Back
Top