kjharve
Board Regular
- Joined
- Jan 4, 2006
- Messages
- 206
Hi all,
I am new to this database lark - trying hard though. What I want to do is use a spreadsheet to update information in a table. The spreadsheet will contain some new records and some existing records. It may also contain some errors - key violations etc. I'll be using VBA to automate this as there will be about 30 tables and 20 or so spreadsheets.
The way I plan to do this is to copy the destination table as a temporary table and add all of the records contained in the spreadsheet using TransferSpreadsheet. Then I will remove any records that have a newer instance and correct any errors.
If I do this though, the table will reject any record of the spreadsheet that does not meet the criteria and dump to an errors table with the expectation that the errors would be corrected manually and re-uploaded. I'd like to remove this responsibility from the user as best I can though.
I guess what I am asking is: how can I create a copy of a table without copying the rules as well?
Am I making life hard for myself? Is there any easier way of doing this?
Help appreciated!
I am new to this database lark - trying hard though. What I want to do is use a spreadsheet to update information in a table. The spreadsheet will contain some new records and some existing records. It may also contain some errors - key violations etc. I'll be using VBA to automate this as there will be about 30 tables and 20 or so spreadsheets.
The way I plan to do this is to copy the destination table as a temporary table and add all of the records contained in the spreadsheet using TransferSpreadsheet. Then I will remove any records that have a newer instance and correct any errors.
If I do this though, the table will reject any record of the spreadsheet that does not meet the criteria and dump to an errors table with the expectation that the errors would be corrected manually and re-uploaded. I'd like to remove this responsibility from the user as best I can though.
I guess what I am asking is: how can I create a copy of a table without copying the rules as well?
Am I making life hard for myself? Is there any easier way of doing this?
Help appreciated!