Consulting

Results 1 to 6 of 6

Thread: CSV file to big to link?

  1. #1
    VBAX Regular
    Joined
    Dec 2019
    Posts
    8
    Location

    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
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,139
    Location
    This sounds like a typical Microsoft Security Update issue, either a Windows or more likely a an MS Office one.
    Can other programs like Excel, Word or Freefileviewer open it?

    If it is an update problem the only fix at the moment is to roll back the update.

    You could also test if Access VBA code can open the file or if it can be Imported directly into Access.

  3. #3
    VBAX Regular
    Joined
    Dec 2019
    Posts
    8
    Location
    Hi

    I have a colleague still on WIN7 and the same file works perfectly fine for them.

    Unfortunately I can roll back as it is a company change to move from WIN7 to WIN10 and they are no longer providing support for WIN7.



    Quote Originally Posted by OBP View Post
    This sounds like a typical Microsoft Security Update issue, either a Windows or more likely a an MS Office one.
    Can other programs like Excel, Word or Freefileviewer open it?

    If it is an update problem the only fix at the moment is to roll back the update.

    You could also test if Access VBA code can open the file or if it can be Imported directly into Access.

  4. #4
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,139
    Location
    Did you try and open it with any other programs on your computer?

    The top thread on this Access Forum has VBA code that opens CSV or text files the old fashioned way that you can try to open the file with.

  5. #5
    VBAX Regular
    Joined
    Dec 2019
    Posts
    8
    Location
    Hi.

    No I don't open the file as I run the risk of corrupting it.

    I can't see the VBA one that you are referring to, do you mind linking it for me.


    Quote Originally Posted by OBP View Post
    Did you try and open it with any other programs on your computer?

    The top thread on this Access Forum has VBA code that opens CSV or text files the old fashioned way that you can try to open the file with.

  6. #6
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,139
    Location
    Take a copy of the file and try and open that instead of the original.
    I can provide the code for you, this code will only open the file and try and input one record or line of data.
    If it works I can modify it to loop through the data and add it to a table.

    Dim strFile as string, strInput as string
    On Error GoTo errorcatch
    strFile =  C\Users\Dave\Desktop\Smith\Mar.csv
    Open strFile For Input As #1
           Line Input #1, strInput
           MsgBox strInput
     Close #1
    
    Exit Sub
    errorcatch:
    MsgBox Err.Description & " " & intCount & " " & strInput
    Close #1

Posting Permissions

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