Importing .txt into a Acess

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sri Vidhya Ganesan - 07 Apr 2005 11:04 GMT

Hi,
I want to import selected contents of the notepad delimited by comma into
a table.can u help me do that?

Reply to this Message

Douglas J. Steele - 07 Apr 2005 12:26 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi,
> I want to import selected contents of the notepad delimited by comma into
> a table.can u help me do that?

Reply to this Message

Sri Vidhya Ganesan - 08 Apr 2005 13:38 GMT

Tx. it worked prefectly.

Reply to this Message