Results 1 to 5 of 5
  1. #1
    stech786 is offline Novice
    Windows XP Access 2013 64bit
    Join Date
    Dec 2017
    Posts
    2

    large excel data

    Hi
    I'm newbie here. I have large excel data files which I need to recon. (24K rows each) total of three files. I need to make sure, if employee IDs match, their location matches etc. Currently, I use vlookup, but it always freezes my PC. I wanted to develop a macro either in Access or Excel to to simple, import the file and auto check mine validation.



    can anyone recommend a good macro tutorials? I have good at excel, tried Access few years.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    get Access for dummies. Its pretty good at explaining.
    I also run imports. during the import I run validation queries....
    1 qry to see if there are missing person fields (missing or non matching ID)
    1 qry to see if there are new persons that were not entered before. Then add to the various tables needed
    etc.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Welcome to the forum......

    Just so we are on the same page (so to speak), "Macro" in Excel means something different in "Access". Excel used to have macro (scripting) for manipulating objects; now Excel uses VBA, but still uses the term "macro" for code.

    Access has macros (scripting) AND VBA coding. I never use macros - they are too restrictive to do much.

    One option is to import the 3 worksheets into Access
    Another is to link the workbooks to Access and the workbooks will appear as table.

    Then you can then create queries to find matching records or find non matching records.
    Or you could write VBA code to do the compares........

  4. #4
    stech786 is offline Novice
    Windows XP Access 2013 64bit
    Join Date
    Dec 2017
    Posts
    2
    Thanks everyone.

    I agree excel macro are too limited. Plus I don't understand their language. I am actually a developer (php, html, javascript). so I won't need any books to read. Just needed to few example, if already created. I can simply tweak those. I haven't worked Access for years. I know I can import or link excel data into Access via some menu options. I rather have one full program that does that

    Any suggestions? Need to make sure if all staff are aligned to the correct project code. etc

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Perhaps you meant to say: "I agree Access macros are too limited."?

    Might find ideas for import at http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Large number of files from excel to access
    By Tyler_Analyst in forum Access
    Replies: 12
    Last Post: 05-09-2016, 04:44 AM
  2. Taking a large Excel workbook and creating a database
    By desertratz in forum Database Design
    Replies: 3
    Last Post: 01-16-2016, 03:11 PM
  3. Adding large amount of Excel data into Access
    By gbmarlysis in forum Access
    Replies: 4
    Last Post: 06-16-2015, 02:34 PM
  4. Exporting to Excel, Procedure Too Large
    By asmores in forum Access
    Replies: 2
    Last Post: 03-08-2015, 11:05 AM
  5. Need help exporting large Access file into Excel
    By phidelt in forum Import/Export Data
    Replies: 2
    Last Post: 02-27-2013, 06:14 PM

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