I have a database whose source data

[yamy]

I have a database where most (but not all) source data is a delimited text file that is updated daily.
I have additional Fields that are not contained in the original text file.

The fields are divided among eight tables that various queries and forms are designed around. These queries and reports are run daily.

Is it possible to create/format an excel template that would allow one "Get External Data/Import" command to distribute the data to the proper tables?

I am happy to read a tutorial if anyone can point me to one -

all comments and ideas welcome
thanks
yamy

 

[JoanneM]

Morning Yamy

I don't think you need the excel detour- have you thought of linking to the text file directly?

you say that eight fields are distributed to different but how are they linked or updated.
More info could help me help you a little more.

regards

jo

 

[yamy]

Thanks Jo,

Tell me, is this the 'Paste Special' option for 'PasteLink' that I just this minute found?

I am off to fool with it and will come back with a better description of the problem if it persists.

thanks again for writing

yamy