I AM HAVING TROUBLE TRYING TO APPEND DATA FROM ONE TABLE TO ANOTHER?
I HAVE TWO TABLES TABLE A AND TABLE B.TABLE A HAS 122 NAMES AND TABLE B HAS IDENTICAL FIELDS BUT NO DATA AS YET.
I CREATED A SELECT QUERY FOR BOTH AND THEN CHANGED QUERY A TO AN APPEND QUERY THE SQL THEN READ
INSERT INTO [LIST BOX B]
FROM [LIST BOX A] INNER JOIN [List Box B] ON [LIST BOX A].[Members bowls data] = [List Box B].[Members bowls data]
WHERE ((([LIST BOX A].[Full Name])="FULL NAME"));
IT IS NOT WORKING
I practised using northwind following the same procedure and it worked!!
i also get a message sometimes that my sql server is not connected but if this is so why does northwind work?
as you can see i am a newbie at this but would like to improve my knowledge of access many thanks dennis
Tks Starr Trekker,when i create the append query and click on run i get the following
microsoft jet base engine cannot find the input table or query"list box B"make sure it exists or spelt correctly
also if i copy and paste your code into the sql statement it removes all the spaces??help and thanks! dennis