Results 1 to 4 of 4
  1. #1
    AudiA4_20T is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Posts
    28

    10 text files (1 million+ lines) that I would like to get into Access

    So I have a list of 10 text files that contain a million+ lines in each. I have them open in notepad but I can't get them into excel because it cuts me off at ~60,000 lines and even when I open the file in excel it doesn't let me open the entire thing. I want to run some queries to match numbers up and eventually export a spreadsheet. What is the easiest way to go about doing this?
    Last edited by AudiA4_20T; 05-16-2012 at 02:51 PM.

  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    Access 2007 has a utility to import a delimited or fixed width text file into a new table. Look for the External Data tab-->text file

  3. #3
    AudiA4_20T is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Posts
    28
    Quote Originally Posted by jzwp11 View Post
    Access 2007 has a utility to import a delimited or fixed width text file into a new table. Look for the External Data tab-->text file
    Perfect. Not sure how I missed that! SOLVED

  4. #4
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    Glad that worked out for you! Good luck with your project.

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

Similar Threads

  1. Importing Text files
    By RayMilhon in forum Programming
    Replies: 4
    Last Post: 10-10-2011, 10:54 PM
  2. Replies: 1
    Last Post: 02-21-2011, 09:55 PM
  3. Replies: 6
    Last Post: 10-14-2010, 08:33 AM
  4. Import Text Files without access
    By 95DSM in forum Import/Export Data
    Replies: 1
    Last Post: 09-10-2010, 04:36 PM
  5. Field returns error when I import Text Files to Access
    By geng in forum Import/Export Data
    Replies: 3
    Last Post: 06-01-2010, 02:20 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