+ Reply to Thread
Results 1 to 5 of 5

Access - records uploaded from Excel; reporting issue

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    Greenville, SC
    MS-Off Ver
    Excel 2016
    Posts
    25

    Access - records uploaded from Excel; reporting issue

    I am trying to upload the attached records from Excel into an Access database.

    In Access I have constructed a report to print out "data only" for two vedors per page for IRS Form 1099-Misc. The problem.......Access returns two records per page of the SAME VENDOR. I need two different vendors per page. It returns two records, same vendor (a duplicate) same page.

    Do I need to include a formula to "move to the next record"? Or is there an option in Access for this, for NO DUPLICATES.

    I did try to upload my Access database, but this website said it was an "invalid file".
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Access - records uploaded from Excel; reporting issue

    You should create the query in Acces that does this for you and use the query as source for the Excel Export
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    01-14-2013
    Location
    Greenville, SC
    MS-Off Ver
    Excel 2016
    Posts
    25

    Re: Access - records uploaded from Excel; reporting issue

    When I import this from Excel both the "report" and the "query" double the records. How do I NOT double the records?

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Access - records uploaded from Excel; reporting issue

    My mistake I was thinking that you were working in Access and importing to Excel, my mistake
    You will have to add a check to see if the record already exist, that will take some vba code.
    Import into a temporary table, check for duplicates and then delete the temp table again.
    I'm not that good with access, sorry

  5. #5
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Access - records uploaded from Excel; reporting issue

    You could try renaming the .accdb file .xlsx and see if that works... then we can rename after download.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

+ 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. [SOLVED] Excel to get records from MS Access
    By aarona in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-01-2017, 07:43 PM
  2. Excel to update records in MS Access
    By aarona in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-28-2017, 05:29 AM
  3. RT reporting to excel...date format issue?
    By acolburn in forum Excel General
    Replies: 0
    Last Post: 05-16-2013, 11:57 AM
  4. [SOLVED] Issue -- cannot embed uploaded image in post
    By teylyn in forum Suggestions for Improvement
    Replies: 10
    Last Post: 03-20-2012, 09:58 AM
  5. Linking access records in to excel
    By jho in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2005, 10:05 AM
  6. Access Records into Excel
    By KJGradwell in forum Excel General
    Replies: 2
    Last Post: 10-04-2005, 02:05 AM
  7. Excel with Access Reporting
    By AB1 in forum Excel General
    Replies: 0
    Last Post: 02-11-2005, 08:34 AM

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