How WPS tables Import txt data

Source: Internet
Author: User

First, open WPS, on the menu bar to execute: file-new blank document, and then we switch to the data options, find the Import data options, open it.

Second, in the Open dialog box, there are two options, the first is to open the data file directly, this allows us to import txt data; there is also an option to use the ODBC data source, which we do not use, tick the first option, and then click to select the data source.

After the completion of the selection, the system will automatically enter the text conversion options, choose Other encoding---ansi/oem--Simplified Chinese GBK. This time there will be a preview to appear, click Next.

Select from the original data type: separator symbol (d)--separate each field with a delimiter, such as a comma or a tab. The start line selection for the import is 1. Click Next.

The separator is selected as Tab key and space, this time can see the preview below. Click Next.

Six, in this step, to select a good target area, click to select the Target Area button.

Seven, this time select the target area, this example selects = $C $: $D $. If the location is identified. Click the Select Area button again to complete the TXT data import into the WPS table.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.