By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,521 Members | 1,259 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,521 IT Pros & Developers. It's quick & easy.

Append from a recordset

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
Thanks but, Using linked text tables is not an option.

Nov 13 '05 #3

P: n/a
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.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.