Import query

[Darrin]

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.

 

[TC]

Write a small macro in Excel VBA to do it at the spreadsheet end?

You could ask in any Excel VBA group, they could tell you how to do
that.

HTH,
TC (MVP Access)
http://tc2.atspace.com

 

[Jeff Boyce]

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/

 

[Jeff Boyce]

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/

 

[Darrin]

thanks

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/