|Access||Adobe photoshop||Algoritmi||Autocad||Baze de date||C||C sharp|
|Calculatoare||Corel draw||Dot net||Excel||Fox pro||Frontpage||Hardware|
|Php||Power point||Retele calculatoare||Sql||Tutorials||Webdesign||Windows|
|Asp||Autocad||C||Dot net||Excel||Fox pro||Html||Java|
If the data is already in some sort of row-and-column format, you can import it. Excel accepts imported data from Word tables, delimited text files, Access databases, or any of a variety of other formats. Let's talk a minute about preparing each of these for the import:
Notice in this line that each of the text strings between the commas is a separate field. In a tab-delimited file, the tab character is used instead of the comma. To prepare a delimited text file, scan it to make sure there are no missing delimiters and that each line has exactly the same number of them.
One way of checking your delimiters in a text file before importing it into Excel is to open it in Word and use Table > Convert > Text to Table on it. If you get the right number of columns -- and the correct data in each column -- the delimiters are okay. If you get more or fewer columns than you expected, your delimiters are somehow off. Note that you shouldn't use spaces with delimiters.
After checking the data to confirm it is Excel-ready, import it as follows:
When you import data, a wizard runs to guide you. The wizard and its steps are different depending on the data type you're importing, so we won't go specifically through the steps here; try it out on your own. You also get to practice this in the assignment for this lesson.
Politica de confidentialitate | Termeni si conditii de utilizare|