Importing Access data

B

BWest

I have an Access program that prepares the data I want in
Excel. I have tried to import using MS Query but the
problem is that the columns change in the data depending
on the criteria I select.
Is there a way to delete the data sheet before refreshing
or, if any of you are Access experts, to assign a label to
the columns even though they change each time I run the
query?
Thanks.
 
P

...Patrick

If i understand... not sure

Range("A1").select
Selection.CurrentRegion.Select
selection.clearcontents


--
....Patrick
Quoi que vous fassiez, faites le bien .
Mail: http://cerbermail.com/?KPW0tTCjFw
Connectez vous sur ce forum par :
news://msnews.microsoft.com/microsoft.public.fr.excel
 

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

Cell data entering slow! 0
Access Query to import from Sharepoint 0
Need Help with a VBA subroutine 0
Creating a Chart on form from selected data in query. 0
Import external data 6
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Some mail merge fields not pulling into document 2
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0

Top