I have a question on best way to import data into the database I am designing. The database has several tables, i.e. taxpayer table with associated data, property table with its associated data. The taxpayer may have multiple properties. The Excel data received from governing body has the data listed per property; therefore, there may be multiple records in the Excel spreadsheet. I am wanting to import the data into the proper tables. My question is on an approach. I am considering two approaches:
1) Try using vba code to read the Excel sheet then process each
record one at a time.
2) Import the spreadsheet into a table using the same field names
then process the data in that table to populate the main data
tables, taxpayer (if needed such as new record) and the property
table with new records. After being process the spreadsheet
table would be cleared.
Any ideas which would be a better approach or another approach?
There may other imports to be made to multiple other tables.
Thanks for any suggestions. (Hopes the above makes sense.)
Rod
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar