Search results

  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...
Back
Top Bottom