Getting data from a csv file

Data menu -> Import External data -> Import data -> locate file -> follow the steps in the Text import wizard (on step 3, select the columns you want to import) -> when it asks where you want to import the data, click on the "properties" button, where one of the options will be how often you want the data to be refreshed.

Does that do what you want?

Originally Posted by MrShorty

Data menu -> Import External data -> Import data -> locate file -> follow the steps in the Text import wizard (on step 3, select the columns you want to import) -> when it asks where you want to import the data, click on the "properties" button, where one of the options will be how often you want the data to be refreshed.

Does that do what you want?

Thanks it works well now, there is one more thing though, the first column that I import displays in excel as 2.01107E+11, this is supposed to be the date and time, before i used the =text function, now if i use the same function (=text) i need to put it in another cell, my question is there any codes or special function that i need to do so that it will auto update and add a new line for the added lines from the csv?

overall, thanks for the guide..it is a big help.