Automatically populating all empty tables in database

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

I have been handed an Access 2000 database with approx. 40
tables. Every table has been stripped, leaving only
column names and data type definitions. My question is
(for the sake of testing a program using the database) can
I quickly populate all the tables in the database with
data corresponding to the field definition? I don't care
about the quality of the content, just as long as it is
populated.
 
-----Original Message-----
I have been handed an Access 2000 database with approx. 40
tables. Every table has been stripped, leaving only
column names and data type definitions. My question is
(for the sake of testing a program using the database) can
I quickly populate all the tables in the database with
data corresponding to the field definition? I don't care
about the quality of the content, just as long as it is
populated.
.
Import some tables from another database and append the
Click to expand...
data to your tables
 
My question is
(for the sake of testing a program using the database) can
I quickly populate all the tables in the database with
data corresponding to the field definition?
Click to expand...

One could write VBA code to do so; but I suspect it would take ten
times as long as just opening each table in datasheet view and typing
in some junk!

There is certainly no built-in method to do this.
 
Hi Jon,

Sometimes it's convenient to create dummy data in Excel and paste-append
the data into the Access tables. Just set up the values or formulas in
the first row or two and then fill or drag down for as many records as
you want.

Use formulas such as =INT(RAND()*1E5) to generate different values in
each record (that gives an integer between 0 and 10000). Excel will also
automatically generate sequential values for dates and strings that end
with numbers.

I have been handed an Access 2000 database with approx. 40
tables. Every table has been stripped, leaving only
column names and data type definitions. My question is
(for the sake of testing a program using the database) can
I quickly populate all the tables in the database with
data corresponding to the field definition? I don't care
about the quality of the content, just as long as it is
populated.
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top