Import query

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

Guest

I have a client that needs a query to import two price/product lists on a
regular basis. One list has 5 columns and the other has 6. Both can be
imported from excell but the first 5 lines in one and the first 7 in another
need to be deleted to get rid of the header info. What is the easiet way to
do this? Any suggestions would be greatly appericated.
 
Darrin

First, "name" the ranges in Excel that contain the data (i.e., exclude the
'header' info).

Second, use File | Get External Data | Import ... and use Named Ranges
instead of entire spreadsheets.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Darrin

Your question implies using an Access query. This may not be the mechanism
you need to use. You could set up a macro (or use a procedure) to run the
import. See my previous response about using named ranges in Excel to zero
in on the material you want to get.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
thanks

Jeff Boyce said:
Darrin

Your question implies using an Access query. This may not be the mechanism
you need to use. You could set up a macro (or use a procedure) to run the
import. See my previous response about using named ranges in Excel to zero
in on the material you want to get.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
Click to expand...
 
Back
Top