+ Reply to Thread
Results 1 to 7 of 7

unable to link .txt file in access 2003

  1. #1
    Registered User
    Join Date
    09-07-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    32

    unable to link .txt file in access 2003

    Hi,

    I am unable to link a .txt file in to access 2003. It gives error File does not contain data.

    File size is 2.7 GB and it is pipe(|) seprated file.

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,177

    Re: unable to link .txt file in access 2003

    Be sure your IMPORT SPEC also is set to read Pipe. (it defaults to comma)

  3. #3
    Registered User
    Join Date
    09-07-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: unable to link .txt file in access 2003

    I am getting this error on selecting the file...I think it because of file size (>2GB)

  4. #4
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,177

    Re: unable to link .txt file in access 2003

    ONLY if the access file > 2Gig, but it would take LOTS of records.
    Even if the txt file is 2Gig, access size can be less. Make sure you start with a compressed access db.

  5. #5
    Registered User
    Join Date
    09-07-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: unable to link .txt file in access 2003

    It i a newly created compressed access......also I am able link other text files in the same db

  6. #6
    Registered User
    Join Date
    09-07-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: unable to link .txt file in access 2003

    still waiting fot reply

  7. #7
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,904

    Re: unable to link .txt file in access 2003

    Since size should not be the issue as Ranman indicated, suggest you upload to the forum a sanitized copy of your db and a copy of your text file with a limited number of records for analysis. You will have to zip the db file and be sure to run a compact and repair before uploading.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. How to delete unwanted backup files after third backup?
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2014, 10:11 AM
  2. Replies: 5
    Last Post: 01-15-2014, 01:52 AM
  3. MS Access 2003 unable to recognize date because of microsecond
    By irfan.rangrej in forum Access Tables & Databases
    Replies: 1
    Last Post: 12-20-2013, 06:18 AM
  4. [SOLVED] Unable to create any link/hyperlinks in a particular excel file
    By Nabanita in forum Excel General
    Replies: 0
    Last Post: 06-21-2005, 07:05 AM
  5. Replies: 1
    Last Post: 01-03-2005, 03:06 PM

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