Importing from excel

[}{]

Guys,

I have a database that basically logs service calls. The calls table has
entries for call no among other things. This call number field has a one to
many relationship with another table (Parts).

When filling in the details, it isn't a problem, I simply click the small
plus sign next to the call and enter parts used in the parts table, this
way, these specific parts are associated with this call.

To make life easier for myself, I have asked some of the guys to record all
of the required info on a spreadsheet and email it to me.

My question is, is it possible to have the import function split the rows in
the spreadsheet so that the required info is put into the call table and the
parts info is put into the assiciated entry in the parts table, using the
import function, or anything else that springs to mind.

Thanks

[KC-Mass]

Re: Importing from excel

Two options:
1.
Stucture the spreadsheet so that it apes the one to many as in
Call# Time Subject Part# PartPrice
0234 10:30 No Video v654 $10.30
0234 v623 $3:20
0234 s89 $11.90
Import that file into a transitory table and then use two queries
to append the appropriate portions of the records to the one
and the many table.

2.
Write a VBA routine to open an instance of Excel. Read the
data directly from the cells in Excel. Take it back to Access
and write the data directly into the one and many table as
appropriate.

Option 1 preferred

Regards

Kevin

"}{" <snoozegroups@b lueyonder.co.uk wrote in message
news:uN%Fk.2257 $qx1.892@newsfe 13.ams2...

Guys,
>
I have a database that basically logs service calls. The calls table has
entries for call no among other things. This call number field has a one
to many relationship with another table (Parts).
>
When filling in the details, it isn't a problem, I simply click the small
plus sign next to the call and enter parts used in the parts table, this
way, these specific parts are associated with this call.
>
To make life easier for myself, I have asked some of the guys to record
all of the required info on a spreadsheet and email it to me.
>
My question is, is it possible to have the import function split the rows
in the spreadsheet so that the required info is put into the call table
and the parts info is put into the assiciated entry in the parts table,
using the import function, or anything else that springs to mind.
>
Thanks
>