Social Buttons
  1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

exporting data to MSExcel/MSAccess

Discussion in 'Keyword Tracker' started by loki, Sep 1, 2004.

0
  1. #1
    not sure i'm doing this right; i want to put the results int an excel file so i export as a csv, then save to disk.
    SEMrush
    excel doesn't seem to want to import, so i've tried with access. i choose comma as the field seperator (duh) but then access refuses to create the db.

    can someone explain what the correct process is?

    TIA
     
    loki, Sep 1, 2004 IP
    SEMrush
  2. l0cke

    l0cke Active Member

    Messages:
    178
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    73
    #2
    Excel
    Save the keyword csv file.
    Click Open in Excel and choose 'Text Files' in the Files of Type dropdown.
    Open the file.

    Access
    Save the keyword csv file.
    Create a new database.
    Click File -> Get External Data -> Import. Choose 'Text Files' in the Files of Type dropdown.
    Open the file.
    The import text wizard should start which will walk you through the steps to import the file.

    HTH.
     
    l0cke, Sep 1, 2004 IP