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. 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
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.