Automate Importing Text file into a table

[SVNTY7]

Hello,
Is it possible to automate the importing of a text document into a table, then once the table is populated, run a query? I would like to have both actions completed with a push of a button. Any help would be greatly appreciated.

Thank you in advance

Svnty7

 

[jc6]

Sure, you can just create a macro which you can execute with the button. Basically there are aproppriate macro actions for both things. "TransferText" action will transfer the data into the specified table (as long as the text file is appropriately formatted) and then "OpenQuery" action will run your query. Just set the action arguments required in each case.
I hope this covers you.

 

[boblarson]

Just a quick addition to what SVNTY7 wrote. The text file should be delimited in some manner. Whether by comma, tab, space, semi-colon, etc.

You can create an import specification to import the text file you have and with it you can specify what fields to import, how they are to be imported (i.e. text, numbers, date/time). Then once you save that spec you can re-use it at any time to import even other text files as long as they are set up with the same delimiter and columns (they have to be in the same exact format).

I hope that's understandable gibberish

For more detailed instructions:
http://www.access-programmers.co.uk...threadid=10175&highlight=import+specification