Importing a spreadsheet

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
 
J

Jim/Chris

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Subscript out of range when importing into access 2010 from excel 0
Excel shortcut options 0
Alt codes 4
Excel Access - importing an excel spreadsheet 0
import files to access 3
Excel Import External Data by Date Automatically 0
import excel spreadsheet without empty rows (causing nulls) 1
Excel Populate Delivery Note 0

Top