Importing .txt into a Acess

  • Thread starter Sri Vidhya Ganesan via AccessMonster.com
  • 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?
 
D

Douglas J. Steele

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top