Importing .txt into a Acess

  • Thread starter Thread starter Sri Vidhya Ganesan via AccessMonster.com
  • Start date Start date
S

Sri Vidhya Ganesan via AccessMonster.com

Hi,
I want to import selected contents of the notepad delimited by comma into
a table.can u help me do that?
 
Select Get External Data, then Import on the File menu.

Once you select the file, a wizard should help you with the rest.

Note that the file extension must be one of .txt, .csv, .tab, .asc, .htm or
..html. See the following KB articles for more details:

"Can't Update. Database or Object Is Read-only" Error Message When You
Import Files
http://support.microsoft.com/?id=245407
How to Import a Text File That Has an Extension That Access Does Not
Recognize
http://support.microsoft.com/?id=306144
 
Back
Top