MySQL Forums
Forum List  »  MySQL for Excel

Re: IMPORT CERTAIN COLUMNS
Posted by: Javier Treviño
Date: May 23, 2017 11:39AM

Hi Stephen,
I am trying to understand what you are doing.
If I get things correctly, you are trying to import data from a MySQL table, when you get the Import Data dialog you are able to see all of the columns in the table and a preview of the data in it before you import.

Notice that by default all columns are selected, you should be able to tell this because the columns have a white background. So if you don't click on any of the columns in the data preview grid, all columns will be imported to the Excel worksheet.

If you click on any of the columns you are changing the default selection, and you should be seeing that the columns you click upon turn to a white background while the rest turn to a grayish one.

Hope this helps, otherwise please describe the problem you are seeing further.

Best regards.

====================================
Javier Treviño
MySQL on Windows Team

Options: ReplyQuote


Subject
Views
Written By
Posted
1376
May 22, 2017 08:47AM
Re: IMPORT CERTAIN COLUMNS
743
May 23, 2017 11:39AM
697
May 23, 2017 12:17PM
599
May 26, 2017 04:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.