philh06
02-19-2009, 08:19 AM
Hi all
Had a quick look around but couldnt find a solution.
I have imported 2 data sheets from excel to access, they are identical in structure (source 1 has the max amount of records excel will allow 65k - source 2 has just over 3k at the moment)
I want to merge both tables so I am able to continue using analysis tools in excel but can find a way to do it.
Thanks in advance:banghead: and just noticed I have also put this in the wrong forum aarrrhhhh
Had a quick look around but couldnt find a solution.
I have imported 2 data sheets from excel to access, they are identical in structure (source 1 has the max amount of records excel will allow 65k - source 2 has just over 3k at the moment)
I want to merge both tables so I am able to continue using analysis tools in excel but can find a way to do it.
Thanks in advance:banghead: and just noticed I have also put this in the wrong forum aarrrhhhh