Recent content by Zaz

  1. Z

    Import + rework large text file, whats fastest ?

    Thanks guys. SQL server is not an option, would be probably best. ChrisO, i have narrowed the problem down to network performance, probably caused by my user profile (how unlikely is that ?). Turns out my collegues can still run this in <10 minutes and so im sticking with reading the file line...
  2. Z

    Import a specific worksheet from Mulitple Workbooks in a folder

    If i recall correctly the method can include the range, something like this: DoCmd.TransferSpreadsheet acImport, 8, "Yourtablename", "filepath of spreadsheet", True, "Sheet2!A1:E273" not sure if the exact syntax is still correct, didnt use it in a long time Rgds Z
  3. Z

    Import + rework large text file, whats fastest ?

    Hi, probably a common topic but search has not been very successful... hope to get some tips here. I use Access 2003 (soon 2010) to import a .txt file with 8 million lines, they are short so its around 500 MB. It has no delimiters, instead the first letter in each line tells me how it is...
See more
Back
Top Bottom