Hi,
My database has a seperate table for comments. The Excel s/s I want to import has a single column for comments eg '28/10 Phoned Patient, 29/10 Patient confirmed appointment, 30/10 Saw Patient'.
I want to convert this column into my table as seperate records eg
PK: 1016 Ref: 11293 Date: 28/10/10 Action: Phoned Patient
PK: 1017 Ref: 11293 Date: 29/10/10 Action: Patient confirmed appointment
where Ref: is the patient Number.
I then want to add records to my database eg
PK: 1018 Ref: 11293 Date: 30/10/10 Action: Saw Patient
At the end of the week, I want to export all of the comments in my table to an Excel spreadsheet, with all of them in one column, then send it to the carers.
When the s/s comes back with any new comments, I need to be able to upload the new comments into my table. I am thinking, get the carers to update a 'New Comments' column, which I can then import into my table??
Any help most appreciated.
Many thanks
PS What are tags?
My database has a seperate table for comments. The Excel s/s I want to import has a single column for comments eg '28/10 Phoned Patient, 29/10 Patient confirmed appointment, 30/10 Saw Patient'.
I want to convert this column into my table as seperate records eg
PK: 1016 Ref: 11293 Date: 28/10/10 Action: Phoned Patient
PK: 1017 Ref: 11293 Date: 29/10/10 Action: Patient confirmed appointment
where Ref: is the patient Number.
I then want to add records to my database eg
PK: 1018 Ref: 11293 Date: 30/10/10 Action: Saw Patient
At the end of the week, I want to export all of the comments in my table to an Excel spreadsheet, with all of them in one column, then send it to the carers.
When the s/s comes back with any new comments, I need to be able to upload the new comments into my table. I am thinking, get the carers to update a 'New Comments' column, which I can then import into my table??
Any help most appreciated.
Many thanks
PS What are tags?
