I am a new user to Heidi SQL. Previously I was using MS Access for my works however in the recent days I have started using Heidi SQL since it was very much user friendly and faster compared to Access.
But I have a big problem in using Heidi SQL compared to Access while importing any excel files. Normally when we import any excel files, Access will create the Temporary Table "Paste Errors" if the data in the excel file is not matching table properties or duplicate entries and it will be useful for me to check and close the errors.
However when I import the same using Heidi SQL, there is no error message or "Paste Errors" table created. Could you please help us to understand how to get the table when we import bulk excel files.
Thanks and Regards R. Vadivelan