Append from a recordset

[Craig.Lee]

I am opening a text file with an ODBC connection. I want to append all
the text data to a table. Going row by row and field by field takes too
long. Does anyone know how I can either reference the text recordset in
an append query or I'd be happy if I could do a maketable to a temp
table and base a SQL from that?

Thanks for your advice.

[Salad]

Cr*******@ppmenergy.com wrote:

I am opening a text file with an ODBC connection. I want to append all
the text data to a table. Going row by row and field by field takes too
long. Does anyone know how I can either reference the text recordset in
an append query or I'd be happy if I could do a maketable to a temp
table and base a SQL from that?

Thanks for your advice.

Usually I do a File/GetExternalData/Link and then select Text (txt)
files and then select the file. I then get an import spec screen where
I can then define the layout of the text file. Once done, the text file
is nothing more than a linked table

[Craig.Lee]

Thanks but, Using linked text tables is not an option.

[Salad]

Cr*******@ppmenergy.com wrote:

Thanks but, Using linked text tables is not an option.

Instead of File/GetExternalData/Link do a File/GetExternalData/Import.
Or use a Docmd.TransferText. You can set up and import/export spec with
this command. Also check out Docmd.TransferDatabase.

If those aren't viable options you can always open the file...see Open,
Close, Write, LineInput, Get, Put, FreeFile, etc in help.