+ Reply to Thread
Results 1 to 4 of 4

Import from excel - how to name headings based on the values that are not in a first row

  1. #1
    Forum Contributor
    Join Date
    01-18-2017
    Location
    Poznań, Poland
    MS-Off Ver
    2016
    Posts
    139

    Import from excel - how to name headings based on the values that are not in a first row

    Hi everyone,

    I wanted to ask if there is a possibility to rename headings of the table based on the values that are in a third raw of tables?

    While importing data from excel Access asks if first raw of data is actually a heading name but can I somehow name the headings based on the raw that is not the first one?

    Thank you in advance for any tip.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Import from excel - how to name headings based on the values that are not in a first r

    Why would you have your headings in the third row and not the first?
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    01-18-2017
    Location
    Poznań, Poland
    MS-Off Ver
    2016
    Posts
    139

    Re: Import from excel - how to name headings based on the values that are not in a first r

    I did get a few hundreds files extracted from CRM system and the structure is like attached: in first raw there is a short message, in second there is nothing and the actual headings names are in third raw.

    The purpose of my question was if there is a way to indicate the third raw as from excel as heading names while imprting Data from Excel into Access.
    Attached Files Attached Files

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Import from excel - how to name headings based on the values that are not in a first r

    I can think of two ways.

    1. Delete the first two rows in Excel either manually or with a Macro.
    2. Look at this link using ADO and VBA-->https://www.onlinepclearning.com/exp...cel-to-access/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Split the excel based on headings list
    By gopalpithani in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2018, 02:25 PM
  2. Split the excel based on headings
    By gopalpithani in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2018, 02:21 PM
  3. [SOLVED] Consecutive repeat of column headings based on cell values
    By mikear82 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-24-2018, 08:49 AM
  4. Show column headings and corresponding values/text based on dropdown selection
    By deedee90 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-03-2018, 07:03 AM
  5. [SOLVED] Sum values in separate sheet based on two headings
    By shaunguyver in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2017, 09:36 AM
  6. Summing values based on criteria located in column and row headings
    By talbarnett in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-02-2015, 02:18 AM
  7. Replies: 7
    Last Post: 01-03-2013, 12:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1