Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Help on Excel Import

velu130486's profile image velu130486 posted 2 years ago in Import/Export Permalink

Dear All,

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

velu130486's profile image velu130486 posted 2 years ago Permalink

Dear All,

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

AndyJ's profile image AndyJ posted 2 years ago Permalink

Hi,

I import from excel a lot and as far as I know you can't see a table of all the errors (anyone?) - it does tell you in the event log area though at the bottom of the screen (have you hidden it?).

The biggest problem I ever face is where characters appear in the excel data that are also used by Heidi to determine the fields, such as the ";/ punctuation marks etc. so you often need to search the excel sheet first to make sure those characters are replaced or dealt with somehow.

Please login to leave a reply, or register at first.