I have used SQL Central a number of times to import data, but now want to edit an Excel spreadsheet and import data that excludes some existing records. No doubt there will be a unique record (like website address or phone number) but I'm not sure of the best way to import limited records. Thank you |
I would create an "Import" table to upload the given Excel file without limitations. Then you could:
Afterwards you can remove this "Import" table. You could also leave it in the database for future imports of the same Excel format. |