Dear Javier, Shay,
First let me start by apologising that I did not read your reaction that you asked for further information. I think I read over it the first time around. Please see my answers to the questions (both latest blog as well as previous blog).
To start of some background information. The table I am trying to edit is based in a database of Wordpress (CMS). I am trying to make some changes in the back-end. The table we are talking about is called wp_posts
1. Can you consistently duplicate this with any table?
• Yes, other tables I can both import AND edit in Excel.
2. If it is a specific table only, what data types do the columns have?
Name Type Collation Attributes Null Default Extra
1 ID bigint(20) UNSIGNED No None AUTO_INCREMENT
2 post_author bigint(20) UNSIGNED No 0
4 post_date datetime No 0000-00-00 00:00:00
6 post_date_gmt datetime No 0000-00-00 00:00:00
8 post_content longtext No None
10 post_title text No None
12 post_excerpt text No None
14 post_status varchar(20) No publish
16 comment_status varchar(20) No open
18 ping_status varchar(20) No open
20 post_password varchar(20) No
22 post_name varchar(200) No
24 to_ping text No None
26 pinged text No None
28 post_modified datetime No 0000-00-00 00:00:00
30 post_modified_gmt datetime No 0000-00-00 00:00:00
32 post_content_filtered longtext No None
34 post_parent bigint(20) UNSIGNED No 0
36 guid varchar(255) No
38 menu_order int(11) No 0
40 post_type varchar(20) No post
42 post_mime_type varchar(100) No
44 comment_count bigint(20) No 0
column Sample information
1 1743
2 1
4 42023.72
6 42023.72
8 [vc_row bg_type="image" bg_grad="background: -webkit-gradient(linear, left top, left bottom, color-stop(0%, #E3E3E3));background: -moz-linear-gradient(top,#E3E3E3 0%);background: -webkit-linear-gradient(top,#E3E3E3 0%);background: -o-linear-gradient(top,#E3E3E3 0%);background: -ms-linear-gradient(top,#E3E3E3 0%);background: linear-gradient(top,#E3E3E3 0%);" parallax_style="vcpb-vz-jquery" bg_image_repeat="repeat" bg_image_size="cover" bg_img_attach="scroll" parallax_sense="25" animation_direction="left-animation" animation_repeat="repeat" video_opts="" bg_override="full" parallax_content_sense="30" fadeout_start_effect="30" overlay_pattern_opacity="80" multi_color_overlay="" multi_color_overlay_opacity="0.6" seperator_type="none_seperator" seperator_position="top_seperator" seperator_shape_size="40" seperator_svg_height="60" seperator_shape_background="#ffffff" seperator_shape_border="none" seperator_shape_border_width="1" icon_type="no_icon" icon_size="32" icon_style="none" icon_color_border="#333333" icon_border_size="1" icon_border_radius="500" icon_border_spacing="50" img_width="48" ult_hide_row_large_screen="off" ult_hide_row_desktop="off" ult_hide_row_tablet="off" ult_hide_row_tablet_small="off" ult_hide_row_mobile="off" ult_hide_row_mobile_large="off" bg_image_new="1745" disable_on_mobile_img_parallax="off" bg_color_value="#000000" viewport_vdo="off" enable_controls="off" overlay_pattern_attachment="fixed" css=".vc_custom_1424954380605{padding-top: 60px !important;padding-bottom: 60px !important;}" parallax_content="parallax_content_value" fadeout_row="off" enable_overlay="off" overlay_pattern="transperant"][vc_column width="1/1"][ultimate_heading heading_tag="h2" alignment="center" spacer="no_spacer" spacer_position="top" spacer_img_width="48" line_style="solid" line_height="1" line_color="#333333" icon_type="selector" icon_size="32" icon_style="none" icon_color_border="#333333" icon_border_size="1" icon_border_radius="500" icon_border_spacing="50" img_width="48" line_icon_fixer="10" main_heading_font_family="font_family:Open Sans|font_call:Open+Sans|variant:600" main_heading_style="font-weight:600;" main_heading_font_size="45" main_heading_color="#ffffff" sub_heading_font_family="font_family:Open Sans|font_call:Open+Sans|variant:300" sub_heading_style="font-weight:300;" sub_heading_font_size="16" sub_heading_color="#ffffff" main_heading="CATEGORY <strong>BANNER</strong>" el_class="heading-bold"]Set banners and description for any category of your website.[/ultimate_heading][/vc_column][/vc_row]
10 Parallax Banner
12
14 publish
16 closed
18 closed
20
22 parallax-banner
24
26
28 42195.08
30 42195.08
32
34 0
36
http://newsmartwave.net/wordpress/porto/dummy/?post_type=block&p=1743
38 0
40 block
42
44 0
3. What Office Version are you using? What version of MySQL for Excel?
• Excel 2013 32-bit
• MySQL 1.3.6
• MySQL Installer 1.4
4. Are you getting any error message? If not, do you see any error messages in the application log found at %APPDATA%\Oracle\MySQL for Excel?
=>> I am not able to locate this folder / log file. Please can you indicate where I should look? I am using Windows 7.
Thanks again.
Naveen