If I have a tableA with columns table_name, column_name , column_value can I read tableA and use it to add the data items specified in the columns of tableA?
For instance: table_name col1_name col1_value col2_name col2_value Employee emp_name Joe Smith birthdate 1/1/50 Employee emp_name Steve Jones birthdate 3/10/53 Transaction Tdate 3/1/2010 Tamount 35.00 Transaction Tdate 3/1/2010 Tamount 25.00 1) The program would open the table specified in the table_name (That's the easy part since you can open a table specified by a string) 2) Then append a row to the table with the col1_value assigned to the column specified in col1_name and the col2_value assigned to the column specified in col2_name? Normally you know the column_names when you write the program and code: Table!Column = Value But can you update a column not knowing it in advance? I.e. can you dynamically compose an sql insert statement and execute it in access? Thanks, Jnana
