Note: When you open a text file in Access (by changing the Files of Type list box to All Files in the Open dialog box and then selecting your text file), Access starts the Link Text Wizard, which allows you to create a link to the text file instead of importing its contents.
Linking to a file is different from importing its contents.
To import data from multiple worksheets, repeat the import operation for each worksheet.
The following are common scenarios for importing Excel data into Access: You can link an Excel range into an Access database as a table.
A text file contains unformatted readable characters, such as letters and numbers, and special characters such as tabs, line feeds and carriage returns.