Query Problem

[thegooser]

I have a lot of queries in Access that I want to put into one table in excel.


Can I put a text feild in the access query to say which query it is from?

Thanks for any help anyone can give

[thegooser]

OK I really didn't explain myself properly there.

I have about 30 csv files to import into Access 2010. They all have the same type of data in them (same fields I guess you would call them). I want to eventually put them all into one big query with all of the data in.

However, I would like to be able to see what record came from which original csv.

Is there any way for me to do this?

Once again, any help would really be appreciated.

[thegooser]

One more thing I forgot to mention...

I can't do anything with the original table as it is a linked csv file. I can't alter the table at all.

[thegooser]

OK I got it.

For anyone interested I added "FileName: "Name Of File"" into a new field in the queries.