user interaction during import?

[Henrootje]

I import in my database several files into several tables using
importdefinitions.
That works like a charm!

But!

(always that inevitable but..........)

Each table has a field that I want to be filled during the
importprocess. I can not have that field read out of the importfile.

I envision a dialogbox that asks the user for input and that value has
to be entered once but from that moment used for all tables!

Code to import.............:

DoCmd.TransferText acImportDelim, "RoCK", "tblQRoCK1",
"c:\RoCK999A.txt", False, ""

Now, how do I fill the field ROCK_Kwartaal_UI with the value entered in


varKwartaalNr = InputBox("Welk kwartaal wordt er geimporteerd?") ?

TIA,

Henro

 

[Arvin Meyer [MVP]]

You cannot add data during the import process. If the field is available
after the import use an Update query. If not, you will need to create the
field, then build the Update query.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Henrootje]

I was afraid it would be like that.....

(sigh)

Oh well, thanks anyway for removing that bit of doubt that was eating
my soul!



Grtz Henro