I am so new to DB and have worked really hard to get where I am, I might be asking the most stupid question but:

Is it possible to insert an excel workbook into a DB which could be opened by on click, the information could be held out side the DB, this which would get over my problem of multiple appointments. If I could have a 12 sheets workbook each representing a month, then month dates in col A, times in col B and then the individule technicians in col beside the dates. Could this be done by maybe a Hypelink, as I say I might be asking the rediculous but hay I can only ask

Thanks Cheryl

I have found this as below but how do I direct it to a specific workbook

Private Sub Command10_Click()
On Error GoTo Err_Command10_Click

Dim oApp As Object

Set oApp = CreateObject("Excel.Application")
oApp.Visible = True
'Only XL 97 supports UserControl Property
On Error Resume Next
oApp.UserControl = True

Exit_Command10_Click:
Exit Sub

Err_Command10_Click:
MsgBox Err.Description
Resume Exit_Command10_Click

End Sub

Cheryl,

Use oApp.Workbooks.Open

Ax