Load filename into column (1 Viewer)

[mik]

Hi, I need to identify which file the data has been imported/loaded from. The objective is to put the filename in a column.

 

[Crilen007]

We need more details

What type of file are they importing
How are they importing it
Where are they importing it to
Why are they importing it
Why do you need this information

 

[mik]

Hi Crilen007,

What type of file are they importing
Its a fixed width field file with all items in ascii character format with a suffix of .dat

How are they importing it
I am hoping to have some sort of button for them to push and then it prompts them for a filename. I'm new to Access (background Oracle/Teradata/Redbrick) and don't know whats easy to do, so I havn't promished the customer how this will be done.

Where are they importing it to
Data will go into a temporary table and then it will be aggregrated and loaded to another table.

Why are they importing it
Temporay reporting solution until they can replace it with a proper "production" report.

Why do you need this information
Loading the filename will permit a unique compound primary key that will prevent human error of loading the same file twice.

 

[ghudson]

This should help get you started...

Browse [Find a directory or file]

Then you can run an update query to add the file name [from the text box that is holding the info] to the correct field in your table.