Results 1 to 4 of 4
  1. #1
    Rich-H is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2020
    Posts
    1

    Removing top 11 rows of data on import of Excel. Go easy (Only a basic understanding of Access :)


    Hi, I have 80+ Excel files which i need to import into Access. However, i need to remove the top 11 rows of data in each file and use the 12th row as the data headings. I am familiar with creating a few queries and macros, but i've never touched VBE. Any help would be much appreciated! Thank you.

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,351
    Did you research TransferSpreadsheet function? You can specify a range if importing into Access, but not if exporting to a spreadsheet. Your issue might be that the ranges are too dynamic, but if they're all the same and it is a one time operation for 80 files, it could work.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  3. #3
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    647
    If that doesn't work you can post a sample excel file and db and we can help with the code.

  4. #4
    trevor40's Avatar
    trevor40 is offline Advanced db Manager
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    402
    You can Import and export to Excel with VBA, you can do it from Access VBA and Excel VBA in both directions, you just have to have the references correct.
    You could use Excel VBA to remove the top 11 rows and then use transferspreadsheet

    1000 ways to skin a cat, allways looking for another one...
    Use MDB format for sample post. If your issue is fixed, mark the thread solved.
    Click on the star below if this has helped.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import Data from Excel returns blank rows
    By mari_hitz in forum Import/Export Data
    Replies: 1
    Last Post: 04-12-2017, 09:35 AM
  2. Need basic understanding assistance
    By pol in forum Database Design
    Replies: 1
    Last Post: 03-10-2017, 02:01 PM
  3. Replies: 4
    Last Post: 04-29-2014, 04:33 AM
  4. Import access query data into excel file, using excel vba
    By exceljockey in forum Import/Export Data
    Replies: 3
    Last Post: 11-15-2013, 02:36 PM
  5. Replies: 4
    Last Post: 12-16-2010, 05:29 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums