multiple excel spreadsheets into one table

  • Thread starter Thread starter stacie
  • Start date Start date
S

stacie

Hello all.

Here's the deal:
I have to import several spreadsheets into one table with historical data.
From the tables, I want to make a form so that the end user will choose which
form to complete to populate the one table. For example, in the form I may
have a line with a patient's name, admit date, discharge date, charges,
future appoint, etc. When the patient is first entered into the data base, I
don't know when the discharge date so I was thinking this would be considered
another form? Also, charges are not know at the time, so this would be
another form. The end goal is to have one table with all information so that
I can query the information. Can anyone tell me where to start?
 
Stacie,

Don't take this wrong, it's an attempt to be helpful. You need to start
with a table structure which stores the required information, and which
provides a foundation for providing the functionaily that you require. To
start that process you have to answer two questions: What is the the nature
of the information that you want to store? What do you want the database to
do for your or your users?

Your post didn't do this, and instead kind of hopped around between a lot of
secondary details.

I'd start with that thought process; it would help you directly, and also
enable you to get more help from this forum.

Sincerely,

Fred
 
Thanks Fred! I appreciate your comment.

I have a table with the labels - patient name, ssn, diagnosis, admit date,
discharge date, charges, auth number, etc. Now I want the users to use a
form to populate the fields in the table. The first person who enters the
information in the table will use a form to enter patient's name, ssn, admit
date. Once the patient is discharged, the user will complete another form
with the discharge date. Another person will complete a form with the
charges and auth number. How can I make the form so that the 2nd and 3rd
persons using the form can only choose names that have already been entered
on the first form? ( I don't want another table and I don't want users
entering demographic information again.) I hope this is better.
 
Hello Stacie,

You second post is a pretty good stand-along description of your
application. It did'nt elaborate on the "import" and "spreadsheet" stuff
from your first post. In order to enable giving some type of answer, I'll
ignore your first post for now.

First, you have to be clear to yourself exactly what constitutes a record in
yoru table. You may think that it's "Labels" or "Patients" but I think that
a record is really an instance of a person staying at your hospital.

So you have one main table and multiple forms.

If you have patient records which are used for several stays, you'll
probably want to split your table into two linked "People" and "Stays" tables
and that would change things.

For your "later forms" who are not allowed to enter a new stay ("patient")
disable the record creation capability on those forms. (Allow editions
property ='no") Also disable editing on any boxes where you don't want to
allow changes. (Locked property = "yes").

Sincerely,

Fred
 
Back
Top