MS Access Database with External Data

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

.tsv Microsoft Access

Janet

2005-09-23, 11:24 am

How does one import a .tsv file directly into Microsoft Access without using
Excel?

Thank you.

John Nurick

2005-09-23, 8:25 pm

The simplest way (if tsv means what I think it does) is to rename it
..txt or .tab.

Otherwise, this http://support.microsoft.com/?id=304206 shows how to
change the extensions that Access will accept, and this
http://support.microsoft.com/?id=306144 includes code that automatically
makes a copy of the textfile with a .txt extension and imports that.

On Fri, 23 Sep 2005 07:44:14 -0700, "Janet"
<Janet@discussions.microsoft.com> wrote:

>How does one import a .tsv file directly into Microsoft Access without using
>Excel?
>
>Thank you.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Sponsored Links