Friday, January 1, 2016

Materi Microsoft Access : Link to a text file

How To link to a text file :
  1. On the External Data tab, click Text File in  the Import & Link group.
  2. In the Get External Data dialog box, click Link to the data source by creating a linked table, click Browse to locate the source file, and then click OK.
  3. In the Link 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 for-mat). Select First Row Contains Field Names if this option applies.
  5. Click Next to work through the remaining pages to set field options, designate a primary key, and name the table.
  6. Click Finish, and then click OK in the Link Text wizard message box that confirms the table was linked. 

No comments:

Post a Comment