Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008
    Posts
    1

    Exclamation Unanswered: 2GB .txt file database

    Hi all,

    To make a long story short, I have 3 databases of phone numbers in a txt format. The problem is the files are between 1.7GB - 2GB.

    I have tried importing and opening the file in Excel and Access, but both applications will not open the file. However, I can open the files on my MacBook with no issues, even though it takes a few minutes to load.

    If anyone out there can help me open/import these files, maybe with other applications, I would greatly appreciate it.

    Thanks,

    DM

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    SQL Server 2005 is a good bet; the express version is free; however you have a limit of 4Gb for a database size with this version.
    George
    Home | Blog

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    can you run SQL server on a Mac?
    if you are int he mac world presumably filemaker would be a contender

    persoanlly I'd dump the data into a SQL engine.. MySQL probably
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Or postgreSQL
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •