Creating duplicate rows of data based on a determined number of ti

Creating duplicate rows of data based on a determined number of ti

Post by QW5uZ » Wed, 10 Jan 2007 08:19:00


I need to be able to write some code for an import or for an append action
where the importing table has one record of data. In the input form I would
have a text box where the user would determine the amount of times this
record would be duplicated. It would append to a table where the primary key
would be an autonumber ID. I'm not sure if this best handled during the
import or through an appending process. Assume the importing table has 7
columns of data. Help if you can!

Thanks-
 
 
 

Creating duplicate rows of data based on a determined number of ti

Post by Jeff Boyc » Wed, 10 Jan 2007 09:05:39

Anne

I'll assume you wish to use MS Access, which is a relational database. I'm
having trouble visualizing a situation in which a well-normalized relational
database table would require a single record to be duplicated.

Can you describe further the issue you are trying to solve by using this
approach?

Regards

Jeff Boyce
Microsoft Office/Access MVP