By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,968 Members | 1,215 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,968 IT Pros & Developers. It's quick & easy.

Importing from excel

P: n/a
}{
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
Oct 5 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

"}{" <sn**********@blueyonder.co.ukwrote in message
news:uN****************@newsfe13.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

Oct 5 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.