+ 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
    121

    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
    MS-Off Ver
    MS Office 2019
    Posts
    18,532

    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?

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

    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
    MS-Off Ver
    MS Office 2019
    Posts
    18,532

    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