Results 1 to 5 of 5
  1. #1
    fried is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2019
    Posts
    3

    CSV file to big to link?

    Hi



    I am using a database that needs to link a file that is 2GB+ I was previously on win7 32bit MS Access 2013 and had no problems with it linking and sourcing the data I need.
    Now that I have migrated over to win10 64bit MS Access 365 I keep getting the following error
    "File C\Users\Dave\Desktop\Smith\Mar.csv does not contain data or the file is to large.
    How do I fix this
    Thanks

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,168
    Was it always 2GB? That would be odd, because AFAIK, the db limit has been 2Gb for a long time, and that includes everything - including overhead.
    A version of sql server would be the answer as to how to "fix" it I would say.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  3. #3
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,190
    As Micron has said, the Access file size limit has been 2GB for almost 20 years. Previously it was 1GB
    However as you are linking the CSV file, that shouldn't increase the Access file size.

    You may be hitting the 1GB recordset limit or your CSV file may be corrupt.
    Try saving the CSV file as an XLSX file then linking that instead.

    Another possible issue is that you may be hitting issues with MaxFileLocks or MaxBufferSize or available connections though I would expect other error messages
    What is the error number with that message?
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  4. #4
    fried is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2019
    Posts
    3
    Hi.

    The file has always been greater than 2GB. normally sits between 2.2GB and 2.8GB and it works with no issues on WIN7. We are just been forced to go to WIN10 as no more support for WIN7

    The error doesn't provide me any error number. just the error itself

    Linked Text Wizard
    File 'C:\Users\Dave\Desktop\NTT_ALL.csv' does not contain data, or the file is too large.

    I will try and save it as a XLSX and see how it goes with that and come back to you

    Thanks

    Quote Originally Posted by isladogs View Post
    As Micron has said, the Access file size limit has been 2GB for almost 20 years. Previously it was 1GB
    However as you are linking the CSV file, that shouldn't increase the Access file size.

    You may be hitting the 1GB recordset limit or your CSV file may be corrupt.
    Try saving the CSV file as an XLSX file then linking that instead.

    Another possible issue is that you may be hitting issues with MaxFileLocks or MaxBufferSize or available connections though I would expect other error messages
    What is the error number with that message?

  5. #5
    fried is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2019
    Posts
    3
    Hi

    No luck with converting to XLSX as the file is over the 1,000,000 lines

    Looks like I have to down the path of SQL Server.



    Quote Originally Posted by isladogs View Post
    As Micron has said, the Access file size limit has been 2GB for almost 20 years. Previously it was 1GB
    However as you are linking the CSV file, that shouldn't increase the Access file size.

    You may be hitting the 1GB recordset limit or your CSV file may be corrupt.
    Try saving the CSV file as an XLSX file then linking that instead.

    Another possible issue is that you may be hitting issues with MaxFileLocks or MaxBufferSize or available connections though I would expect other error messages
    What is the error number with that message?

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

Similar Threads

  1. Link to file
    By sdc1234 in forum Access
    Replies: 5
    Last Post: 07-10-2013, 10:44 AM
  2. Trying to link to a file
    By wrbuchanan2 in forum Queries
    Replies: 3
    Last Post: 04-20-2013, 10:27 PM
  3. Replies: 2
    Last Post: 12-27-2012, 09:37 AM
  4. Replies: 1
    Last Post: 07-26-2011, 05:18 PM
  5. Text File Link
    By pkell658 in forum Import/Export Data
    Replies: 1
    Last Post: 03-23-2010, 04:46 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 - Senior Forums