Dear All,

I have hospital payroll dept file in excel which has data directorate,
departments, wards , grade , budget etc. This file has alot of filter
information. I want to import this file in access 2000 and generate
reports based on user select different options from a form built in
access.

any suggestions r more welcome. If u r willing to help me i can email
u file too

thx in advance

Neha

Neha:

The import may be trivial.
Just goto File/Import in Access and try it.

You will get one of 4 results.

A correct usable table.
--------------
An error message on some columns, but a good import otherwise.
This occurs if the columns are not uniform. The import allows
for the first row as headers. It then assumes that the first item in
a column is the pattern for the others, so if the first item is a
number and the next is text it will complain.
----------------------------
A failure to import with no explanation. If this happens, use Excel
to export the file to CSV format. Then import that.
----------------------------------------------
A good import that is not usable.

If your Excel sheet looks like this:

Product ID: XXXX

New York yyyyy
New Jersey zzzzz

Product ID: AAAA

New Hampshire bbbbb


it will import fine, but the table will be useless without using code
to fix it.

Good luck

Ira Solomon

On 5 Jan 2004 06:31:59 -0800, newlooks4u (AT) hotmail (DOT) com (Neha) wrote:

Thanks for your reply. the detail of file is as follow


I have excel file which has information about Payroll department of a
hospetal. The excel sheel is filetred based on department , wards,
staffgroup etc. I have imported the excel file in Access 2000

I want that user can select various options based on departments,
wards, staffgroup etc and then print the report whatever he has chosen

I have created the form with the following combo boxes

Directorate(All, or usercan select one)
Service Area(All, or depending upon the Directorate selected by user)
Ward (All, or depending upon the staffgroup selected by user)
Grade(All, or depending upon the ward selected by user)

After selecting these options user will click on Report button and the
report should show the name of the selections and the related budget
information

I have one table which stores all the information. Any help will be
higly appreciated

Regards

Neha

Ira Solomon <isolomon (AT) solomonltd (DOT) com> wrote