I am trying to import a table from Access and/or Excel. I have attempted with both programs. I get errors possibly due to some bad data over the years. Is it possible to tell SQL Server to import a table and discard any errors? or is there a way to scrub the data before importing to make sure all possible causes of errors are corrected or addressed?
Hello my friend,
I would clean the data before attempting an import. Deleting data that you know is bad is quicker than trying to clean it, every record older than 3 years for instance not fitting in with new structure. I cannot recommend anything else without seeing the structure or a sample of the data. Good luck.
Kind regards
Scotty
|||
Hi,
You can try to use DTS or SSIS to import data. But it is not contained in the Express edition.
|||I agree with Scotty. Ensure the import data fits the existing structure and rules within your database before attempting to import it. Anything that does not conform should be deleted. Only import good data that passes whatever test you set it.
No comments:
Post a Comment