Wednesday, December 30, 2015

Materi Microsoft Access : Import data from a text file into a new table

How to import data from a text file into a new table :
  1. On the External Data tab, click Text File in the Import & Link group.
  2. In the Get External Data dialog box, click Import the source data into a new table in the current database, click Browse to locate the source file, and then click OK.
  3. In the Import Text wizard, specify the format for the file you are importing (Delimited or Fixed Width), and then click Next.
  4. Choose the delimiting character or specify column breaks (depending on the format selected in step 3). Select First Row Contains Field Names if this option applies.
  5. Click Next, and then work through the remaining pages to set field options, designate a primary key, and name the table.
  6. Click Finish. If you want to save the steps in this operation, select Save import steps in the Get External Data dialog box.

No comments:

Post a Comment