Recent content by ASharifs

Thanks. Appreciated .. A.

Lovely !. It worked and I really appreciate your help. Only if you have time and this is just to make it even better .. The tables names ( both destination and the source ) are hard-coded. Beside specifying the source root Is it also possible to let the end user specify the table name as well...

Thanks .. it worked !. There is one little problem: It works only if the Destination table was the only one in the database file; or if it was the first among the other tables ! so I had to rename it till it was on top of the tables list. Is there anyway to solve this ?. May I also ask the...

Thanks for the reply. Actually I wanted the end user to be prompted to input the mother table name ( Destination ); and prompted to type the name/location of the child table ( Source ). Thanks ..

Hi I am trying to convert some Excel files to Access: File > External > Import etc. I have already built Access tables and relationships. The problem is: The Excel report I have corresponds to fields from diffrent Access tables. How can I export them to diffrent tables ? The other problem is...

Hi I am trying to Append 100's of diffrent tables to one master table that have the the same fields. The tables are at diffrent locations, and once it's done I want to start with a new master table name and append to it many child tables of its own family and so on. I used the following SQL...