I have created a SQL Database which contain 1024 column, for my own reasons, but would like to populate it in two ways.
The first 512 columns I would like to populate with the column (Field) name.
The second 512 I would like to popluate with random values between 1-100.
I have the code in VB to perform the functions, except ADO or something! is giving me a headache!
It will poulate upto roughly 500 fields in the first instance but no more and fails with more when triggering the .update command after .AddNew and my population code.
Can anyone suggest how I can populate 1024 fields per recordset by any method so I can get things done!
Cheers!
The first 512 columns I would like to populate with the column (Field) name.
The second 512 I would like to popluate with random values between 1-100.
I have the code in VB to perform the functions, except ADO or something! is giving me a headache!
It will poulate upto roughly 500 fields in the first instance but no more and fails with more when triggering the .update command after .AddNew and my population code.
Can anyone suggest how I can populate 1024 fields per recordset by any method so I can get things done!
Cheers!