Recent content by deepakes2

Can someone help me write a function to do the above task . Thanks

the file is usually too big to copy into excel. Thank you for the help . I am kind of looking if i can do something like INSERT INTO mastertable ( * ) SELECT * FROM Table1; I dont know if this will work. plz also let me know if there is a code i can copy paste to make this work. Thanks

Can you plz simplify the process you just mentioned . Can you also let me know if there are any other easy ways to do this . Thanks.

I have various access databases created one every month for about 2 years . each access file contains identical data auto generated tables end of the day. My task is to merge all the tables into one table for each month. january dbo table 1 table 2 . . Table 31 to table : january . I want to...

Hello - I have a database with bunch of identical tables. Tables: same table structure auto generated every day. I want to make all the tables into one table . I want to keep all the records (do not want to take the duplicates out). Please help me with this . Thanks for looking

Query wizard is not working . returning only one value In this case only one row associated with ID:1 not able to show other rows associated with the ID. I have numerous records like ID:1 . I have to display all the records in the output.

How Can I transpose the Following: Can you help me write a query in Access to transpose the data Table : Transpose ID score course 1 3 M 1 4 C 1 T 1 4 E 1 4 M 1 5 C 1 2 T 2 M 2 3 T 2 5 E 2 11 R 3 3 M 3 4 C 3 6 R desired output ID M C T E R .. 1 3 4 - 4 - 1 4 5 2 - - 2 - - 3 5 11 3 3 4 - -...