Need to create test data from prod

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to retain the actual data but but mismatch the columns to produce test
data for a development group. For example, for a table containing UserID,
Name, and SSN the values must be retained but not be in the same record.
Example:
Actual
UserID Name SSN
ABCD Doug 123-45-6789
DCBA Mary 987-65-4321
EFGH Brad 432-11-7897
Test File
ABCD Mary 432-11-7897
DCBA Brad 123-45-6789
EFGH Doug 987-65-4321

Can I do this in a query or through VBA code?
 
If this is a one time shot I would copy to Excel, sort name column alone
ascending and SSN sorted alone descending. This will mix them up as you
indicate.
 
The table is very large, 1.3 million records with 40 fields, so Excel 2003 is
not an option unfortunately - 1.2 gigs. Can Excel 2007 do it?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Aggregate query - Displaying field associated with MAX record 3
Finding count of unique number within a specific criteria? 7
novice question - import text file w field ids on each row to Acce 1
import text file to Access database 2
Transfer data from sheet A to Sheet B 2
Newbie needs help: how to fill in new table with any unchanged info from existing table 3
Remove lines from text file prior to importing in Excel 3
Need help using data from multiple worksheets to create a Summaryreport 1

Back
Top