Template Wizard with one-to-many relationship - Challenge

carmo

New Member
Joined
Oct 12, 2002
Messages
3
The template wizard seems to be able to write one record at a time to an Access database. I cannot find a way to write to more than one record on any given table. For example, an employee can speak many different languages, where each language spoken is a different record in the database. If you put a excel form with 4 input cells for language, how do you write these 4 languages to 4 different records in a database.....confusing I know.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
If you have an appropriate table in Access like...

EMP-LANGUAGES(Emp#,Language)

where the name of the language is part of the key, I don't see why not.
 
Upvote 0
Lets say in your Excel form you have this:

Langauge: _________
Language: _________
Language: _________

Where each "________" is a seperate cell.

How would you get the template wizard to write these four languages as 4 seperate records of a database table? The wizard asks the user to match a database field with a cell of the spreadsheet. It does not let you assign more than on cell to a database field.
 
Upvote 0
On 2002-10-14 17:05, carmo wrote:
Lets say in your Excel form you have this:

Langauge: _________
Language: _________
Language: _________

Where each "________" is a seperate cell.

How would you get the template wizard to write these four languages as 4 seperate records of a database table? The wizard asks the user to match a database field with a cell of the spreadsheet. It does not let you assign more than on cell to a database field.

Carmo,

I was merely concerned with the receiving end, that is, Access. I'm afraid you need a VBA programmer for this particular question.

Aladin
 
Upvote 0

Forum statistics

Threads
1,226,505
Messages
6,191,434
Members
453,657
Latest member
DukeJester

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top