I am hope to get some help from all you experienced Access programmer.
I am trying to help out a co-working that really need some help in
getting some date organized. I do have some Access experience, but I
do not have a lot of work with queries.

I have 12 spread sheets that he receives from a vendor and I would
like to put the information into a database and have some of the data
queried. I have already put the older information into a table in
access.

1. . Going forward what I would like to do is when we receive the
spreadsheet is have my have a the database import the data from the
spreadsheet hopefully with the click of a button. The spread sheet
has 63 columns of information but I would only need to import 44
columns of the data. Is it possible to make query that will do this
automatically?

2. I have a bill from and bill to column that I would like to verify
that is no more than 30 or 31 days. Ex 4/1/03 - 4/30/03.

3. I also need to gaps in the bill period it CircuitID. Ex. 3/1/03 –
3/31/03, 5/1/03 – 5/31/03. no billing for April.
4. Overplay in billing period to see we are not be billed twice for
the same CircuitID.


I know the information is not really detailed but if you email
directly or thru the group I will provide more information.
Thank you in advance..

"RC" <rc790 (AT) yahoo (DOT) com> wrote

Not a query, but a macro/code can import from Excel into a table.

Simply create a query and use the criteria you need to filter out records.

As above.

As above.

Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/reponse