![]() In the example below, the imported fields are labeled “Name" and "Address."Ĭlick the “Save As” button and change the Specification Name. ![]() In the Field Information section, change the field names to the original column heading. When clicking the OK button it will to open the “Import Text Wizard” dialog box as shown below.Ĭlick the “Advanced” button to open the “Import Specification” dialog box. Select the file from the File Open dialog box and click Open. ![]() Click the Browse button to select the file name. Select “ Text File” from “ Import & Link” group from the “ External Data” tab in Microsoft Access Ribbon.Ī dialog box called “Get External Data – Text File” will open as shown in the figure below. Open the “Sample.accdb” database in Microsoft Access. The database “Sample.accdb” is used as an example. Here is a step-by-step process for creating an import specification. When you want to import text files in Access it can be saved as a specification and imported using VBA code. Creating an Import Specification in Access 2003
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |