S
stag246
Ok, Well i have been search this topic for a while and still have not a clue
if its possible.
Specifications: Windows XP SP2, OFFICE2003
My company has a mess with schedules. They are still using an old way which
they have all the schedules in excel files named with the consumer name as
the title (lastname, firstname). There are 3 worksheets in each workbook.
(Hours~schedule, backup, Consumer info). There are over 800 consumers with
the company. They have been trying lately to organize them better by Creating
letter folders A-Z. Now there was alot of info that might not help.
Here is where i need some help:
They want to know if i can import most of the information from the various
worksheets in each workbook into a table so that they will not have to sit
there and rekey all the information.
So is there a way to extract certain ranges of information from excel and
importing it into access. Example, from sheet one I need to get consumer name
([PAY$D1]), coordinator([PAY$D9:G9]), attendant([PAY$B18:B31]), Scheduled
times (Monday-Friday, each in their own columns)(ETC.). But the sheets arent
setup where each fields title is above the field, such as the consumer name
is :
Consumer Name: ********
Not how it probably should have been
Consumer Name:
***********
Thanks in advance for any help.
if its possible.
Specifications: Windows XP SP2, OFFICE2003
My company has a mess with schedules. They are still using an old way which
they have all the schedules in excel files named with the consumer name as
the title (lastname, firstname). There are 3 worksheets in each workbook.
(Hours~schedule, backup, Consumer info). There are over 800 consumers with
the company. They have been trying lately to organize them better by Creating
letter folders A-Z. Now there was alot of info that might not help.
Here is where i need some help:
They want to know if i can import most of the information from the various
worksheets in each workbook into a table so that they will not have to sit
there and rekey all the information.
So is there a way to extract certain ranges of information from excel and
importing it into access. Example, from sheet one I need to get consumer name
([PAY$D1]), coordinator([PAY$D9:G9]), attendant([PAY$B18:B31]), Scheduled
times (Monday-Friday, each in their own columns)(ETC.). But the sheets arent
setup where each fields title is above the field, such as the consumer name
is :
Consumer Name: ********
Not how it probably should have been
Consumer Name:
***********
Thanks in advance for any help.