Docmd.TransferText

[JimS]

I've gotten this to work. Couple of issues:

1. The "Import Specification" seems to be kept somewhere mysterious. I'm
using a sandbox front end to create it. How do I transfer this spec to my
production front end?
2. Row one of my .TSV file has the report title and some other information.
I'm happy to discard it, but how? Row two has the Column Headers. Since I now
have an import spec, and I'm importing into an existing table, can I just
specify that there are no column headers, import the whole shebang, then
delete the spurious rows? Or is there a simpler way. This file has 100,000+
rows, so I can't read it into Excel 2003. I did strip row one out using
Notepad. Ideas?

 

[Ken Snell \(MVP\)]

Specification can be copied from one database to another by going to the
database that should "receive" the specification, click File | Get External
Data ... | Import, click the Options button in the popup window, and select
the specifications by checking the correct checkbox. Then continue the
import wizard.

The actual specifications are stored in two system tables, which are not
designed for human "use".

The best approach is to import the entire text file, find the "unneeded"
record in the table, and delete that record; just as you suggest.