Thread: Import Help

help!

I just found this site and thank god I did. I don't know what is happening with my programming but it's not doing what I want.

When I run the code below it runs fine, except all the import data is added, except with all the previously cleared data. So instead of ending up with this:
|One table of data|

i get this:

|Newest table of data|Info from before that||table from iteration before that|
This continues all the way to the first time I imported information.

Can someone look at my code and tell me why I'm stupid as hell?

Thanks in advance for a solution that will make me look disabled.

Sub SetAssays()
Sheets("ASSAYS").Select
    With Sheets("ASSAYS").QueryTables.Add(Connection:= _
        "TEXT;" & ThisWorkbook.Path & "\Assays.CSV", Destination _
        :=Range("$A$1"))
        .Name = "Assays"
        .FieldNames = True
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = True
        .RefreshOnFileOpen = False
        .RefreshStyle = xlInsertDeleteCells
        .SavePassword = False
        .SaveData = True
        .AdjustColumnWidth = True
        .RefreshPeriod = 0
        .TextFilePromptOnRefresh = False
        .TextFilePlatform = 850
        .TextFileStartRow = 1
        .TextFileParseType = xlDelimited
        .TextFileTextQualifier = xlTextQualifierDoubleQuote
        .TextFileConsecutiveDelimiter = False
        .TextFileTabDelimiter = True
        .TextFileSemicolonDelimiter = False
        .TextFileCommaDelimiter = True
        .TextFileSpaceDelimiter = False
        .TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, _
        1, 1, 1, 1, 1, 1, 1, 1, 1)
        .TextFileTrailingMinusNumbers = True
        .Refresh BackgroundQuery:=False
    End With
    Call RefreshQueryTables
End Sub

The location can be important when the question/answer involves the poster's regional settings.
If you really like to be funny, we have a "Water Cooler" forum where you can share your humor with everybody.

As for the title, how better the description of your problem, how faster an answer can be given.